Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Insert a row using the CURRENT_TIMESTAMP function for both columns

SQL> SQL> create table t(   2     c1 timestamp with time zone,   3     c2 timestamp with local time zone   4  )   5  / Table created. SQL> SQL> insert into t (c1,c2)values( current_timestamp, current_timestamp ); 1 row created. SQL> SQL> select * from t; C1 ------------------------------------------------------ C2 ------------------------------------------------------ 26-OCT-09 10.31.37.646000 AM -06:00 26-OCT-09 10.31.37.646000 AM 1 row selected. SQL> SQL> drop table t; Table dropped. SQL>