Syntax: TO_DATE (date, format)
Example: TO_DATE('11/11/2010 13:00:00', 'dd/MM/YYYY HH24:MI:SS') - in this case for 24 hours. For 12 hours, you should also specify AM or PM.
Find out more in this website (another one that I hope lasts forever) - http://www.techonthenet.com/oracle/functions/to_date.php
No comments:
Post a Comment