Sysdate – Oracle SQL Function

SYSDATE returns a DATE that represents the date and time set on the operating system of the machine Oracle is installed on.

The format of SYSDATE is controlled by the NLS_DATE_FORMAT session parameter.

Example:

SELECT SYSDATE FROM DUAL;

SYSDATE
——————-
21-SEP-2005 22:45:05