Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

TIMESTAMP specifies a precision for the SECONDS field in a TIMESTAMP column (the DATE data type can only store whole seconds

SQL> SQL> create table other_MyTable (   2        event_name         varchar2( 100 ),   3        event_date         date,   4        event_timestamp timestamp ); Table created. SQL> SQL> insert into other_MyTable( event_name, event_date, event_timestamp ) values( 'A', sysdate, sysdate ); 1 row created. SQL> SQL> column event_name      format a28 SQL> column event_date      format a18 SQL> column event_timestamp format a28 SQL> SQL> select event_name, to_char(event_date, 'DD-MON-YY HH24:MI:SS') event_date, event_timestamp   2  from other_MyTable; EVENT_NAME                   EVENT_DATE         EVENT_TIMESTAMP ---------------------------- ------------------ ---------------------------- A                            10-JUN-08 17:06:23 10-JUN-08 05.06.23.000000 PM SQL> SQL> drop table other_MyTable; Table dropped.