Personal Knowledge Base
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment