SYSDATE
SYSDATE

Returns the current date and time. The time component of the result includes hours, minutes, and seconds. SYSDATE is also known as a pseudo-column. See Chapter 1 for more information.

Examples

SQL> SELECT SYSDATE FROM dual;

SYSDATE
-----------
21-May-2000

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-Mon-YYYY hh24:mi';

Session altered.

SQL> SELECT SYSDATE FROM dual;

SYSDATE
--------------------
21-May-2000 15:16:40

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial