Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Getting the Current Date in the Session Time Zone

SYSDATE() function gets the date for the operating system where the database resides. You can get the date in your session time zone using the CURRENT_DATE() function. SQL> SELECT CURRENT_DATE FROM dual; CURRENT_D --------- 31-MAY-07 SQL>