SYSDATE in Oracle

SYSDATE

SYSDATE is used to get the system date and time.This return values in format of "nls_date_time"

SQL>SELECT sysdate FROM DUAL;

Note:-We can change the format of nls_date_time for session by below command.

SQL>ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

Now you will get the result in above mentioned format.

 

SQL>SELECT sysdate FROM DUAL;

 

Below is expression list that can be used in different queries

 Examples:-