Skip to main content
Returns the current local date in the time zone specified in the session’s time_zone setting.

​
Syntax

The function can be called with or without parentheses: 
CURRENT_DATE
CURRENT_DATE()

​
Return Type

DATE

​
Remarks

The function gets the current timestamp from the system, converts it to the time zone specified in the time_zone setting, and truncates it to a DATE value.

​
Example

The following example assumes that the current timestamp is 2023-03-03 23:59:00 UTC. It displays the current date in the time zone Europe/Berlin. 
SET time_zone = 'Europe/Berlin';
SELECT CURRENT_DATE();
Returns 2023-03-04 Notice that the time zone conversion from UTC to Europe/Berlin causes the resulting date to be 2023-03-04 instead of 2023-03-03.
⌘I