Friday, February 20, 2015

Oracle datetime operations

- String to Date Conversion:
TO_DATE('12/16/2012 04:00:00', 'MM/DD/YYYY HH24:MI:SS')

- Date to String Conversion: 
TO_CHAR(sysdate,'YYYYMMDDHH24MISS')

Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)