Oracle PL/SQL Tutorial/Date Timestamp Functions/CURRENT TIMESTAMP

CURRENT_TIMESTAMP()

SQL>
SQL> SELECT CURRENT_TIMESTAMP from dual;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.328000 PM -07:00
SQL>

Insert a row using the CURRENT_TIMESTAMP function for both columns:

SQL>
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>