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. Returns 2023-03-04 because the time zone conversion from UTC to Europe/Berlin shifts the date from 2023-03-03 to 2023-03-04. 
SET time_zone = 'Europe/Berlin';
SELECT CURRENT_DATE();