CURRENT_TIMESTAMP() : CURRENT_TIMESTAMP « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. CURRENT_TIMESTAMP

SQL>
SQL> SELECT CURRENT_TIMESTAMP from dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
31-MAY-07 08.35.20.328000 PM -07:00

SQL>