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

Похожие материалы