CURRENT_DATE
Returns the current date.
PostgreSQL 17.5
CURRENT_DATEReturn value
A date (date) at the start of the transaction
Examples
Current date
PostgreSQL 17.5
SELECT CURRENT_DATE;Date a week ago
PostgreSQL 17.5
SELECT CURRENT_DATE - 7 AS week_ago;Details
The date is taken in the time zone from the TimeZone setting, which is UTC in the sandbox. You can add and subtract whole days: CURRENT_DATE - 7 is also a date, and the difference of two dates is a whole number of days.