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.

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();