CURRENT_PGDATE
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_PGDATE
CURRENT_PGDATE()
Return Type
PGDATE
Remarks
The function takes the current Unix timestamp (in the UTC time zone), converts it to the time zone specified in the time_zone
setting, extracts the date part, and returns it as a PGDATE
value. Two simultaneous calls of the function can return different dates, due to time zone conversion.
Example
The following example assumes that the current Unix timestamp is 2023-03-03 23:59:00 UTC
. Observe how we return different dates with different time zone settings:
SET time_zone = 'Europe/Berlin';
SELECT CURRENT_PGDATE; --> 2023-03-04
SET time_zone = 'America/New_York';
SELECT CURRENT_PGDATE; --> 2023-03-03