Tuesday, September 20, 2011

easy way to find record in some table changed in specified date

SELECT A.BONDING_GROUP_SEQ,TO_TIMESTAMP(TO_CHAR(A.MODIFY_DATE,'DD-MM-RRRR HH24:MI:SS'),'DD-MM-RRRR HH24:MI:SS') FROM DTT_BONDING_GROUP a where trunc(A.MODIFY_DATE) = '19-SEP-11'

No comments:

Post a Comment