AdvancedDate & Time Functions

Time zone conversion and handling

The query

SQL

SELECT
  NOW() AT TIME ZONE 'UTC' AS utc_time,
  NOW() AT TIME ZONE 'Asia/Kolkata' AS ist_time,
  NOW() AT TIME ZONE 'America/New_York' AS ny_time,
  TIMEZONE('Asia/Tokyo', NOW()) AS tokyo_time;

Tested against PostgreSQL 16

Note

“Always store timestamps in UTC (TIMESTAMPTZ). Convert at query/display time using AT TIME ZONE.