Date and time functions
CURRENT_DATE
Reference material for CURRENT_DATE function
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:
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
.
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
.