Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyDate & Time Functions

CURRENT_DATE, NOW(), CURRENT_TIMESTAMP

The query

SQL
SELECT
  CURRENT_DATE AS today,
  NOW() AS current_datetime,
  CURRENT_TIMESTAMP AS current_ts,
  CURRENT_TIME AS current_time,
  LOCALTIME AS local_time,
  LOCALTIMESTAMP AS local_ts;
Tested against PostgreSQL 16

Note

“NOW() includes timezone (TIMESTAMPTZ). LOCALTIMESTAMP is timezone-naive. Use NOW() for consistency.