Premium
Log in
PostgreSQL Function Reference
DATE
Extracts the date part from a datetime.
PostgreSQL 17.5
DATE(datetime)datetime
The datetime
Examples
PostgreSQL 17.5
SELECT DATE('2022-12-05 10:37:22')DATE(datetime)SELECT DATE('2022-12-05 10:37:22')