SQL> SELECT SYSTIMESTAMP "TIMESTAMP", CAST(SYSTIMESTAMP AS DATE) "DATE" 2 FROM dual; TIMESTAMP DATE --------------------------------------------------------------------------- --------- 26-OCT-10 03.57.07.220160 PM +04:00 26-OCT-10
SQL> SELECT SYSTIMESTAMP "TIMESTAMP", CAST(SYSTIMESTAMP AS DATE) "DATE" 2 FROM dual; TIMESTAMP DATE --------------------------------------------------------------------------- --------- 26-OCT-10 03.57.07.220160 PM +04:00 26-OCT-10