{"id":534,"date":"2017-08-07T09:51:26","date_gmt":"2017-08-07T02:51:26","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=534"},"modified":"2025-05-11T18:17:55","modified_gmt":"2025-05-12T01:17:55","slug":"oracle-current_date","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/oracle-date-functions\/oracle-current_date\/","title":{"rendered":"Oracle CURRENT_DATE"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the Oracle CURRENT_DATE<\/code> function to return the current date in the session time zone.<\/p>\n\n\n\n

Introduction to the Oracle CURRENT_DATE function #<\/a><\/h2>\n\n\n\n

The CURRENT_DATE<\/code> function returns the current date and time in the session time zone. The CURRENT_DATE<\/code> function requires no argument:<\/p>\n\n\n

CURRENT_DATE<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Getting the current date and time example #<\/a><\/h2>\n\n\n\n
First, change the default date format to a new one that includes the time value:<\/p>\n\n\n
ALTER<\/span> SESSION<\/span> SET<\/span> NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span>\n  SESSIONTIMEZONE\nFROM<\/span>\n  DUAL;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Currently, the session time zone is set to -07:00<\/code>.<\/p>\n\n\n\n
Third, get the current date and time in the session time zone using the CURRENT_DATE<\/code> function:<\/p>\n\n\n
SELECT<\/span>\n  CURRENT_DATE<\/span>\nFROM<\/span>\n  DUAL;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
06-AUG-2017 19:43:44<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Changing session time zone #<\/a><\/h2>\n\n\n\n
If you change the session time zone, the value of the current date is adjusted accordingly as shown in the following example:<\/p>\n\n\n\n
First, set the session time zone to -09:00:<\/p>\n\n\n
ALTER<\/span> SESSION<\/span> SET<\/span> TIME_ZONE<\/span> = '-09:00'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Second, get the current date in the session time zone:<\/p>\n\n\n
06-AUG-2017 17:45:33<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The new current date was adjusted to about -2 hours as expected.<\/p>\n\n\n\n
Using CURRENT_DATE as default value #<\/a><\/h2>\n\n\n\n
First, create a new table<\/a> with the event_date<\/code> column whose values default to the current date and time of the session time zone:<\/p>\n\n\n
CREATE<\/span> TABLE<\/span> events<\/span>(\n    id<\/span> NUMBER<\/span> GENERATED<\/span> ALWAYS<\/span> AS<\/span> IDENTITY<\/span> PRIMARY KEY<\/span>,\n    event_name VARCHAR2<\/span>(255<\/span>) NOT<\/span> NULL<\/span>,\n    event_date DATE<\/span> DEFAULT<\/span> CURRENT_DATE<\/span>\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
INSERT<\/span> INTO<\/span> events<\/span>(event_name)\nVALUES<\/span>('Oraccle CloudWorld'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, retrieve data from the events<\/code> table:<\/p>\n\n\n
SELECT<\/span> * FROM<\/span> events<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
You’ll see the time at the moment you execute the query in the event_date<\/code> column.<\/p>\n\n\n\n
Summary #<\/a><\/h2>\n\n\n\n
    \n
  • Use the Oracle\u00a0\u00a0CURRENT_DATE<\/code> function to get the current date and time in the session time zone.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t
Second, insert a new row<\/a> into to the events<\/code> table:<\/p>\n\n\n
Seccond, retrieve the current SESSIONTIMEZONE<\/code><\/a> function:<\/p>\n\n\n
The CURRENT_DATE<\/code> function returns a DATE<\/code><\/a> value in the Gregorian calendar. Note that the DAT<\/code>E includes both date and time.<\/p>\n\n\n\n