TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH TIME ZONE is a SQL function in the Date/Time Functions category. PostgreSQL: timezone-aware timestamp. Stores values in UTC internally but displays in session timezone. The syntax is TIMESTAMPTZ / TIMESTAMP WITH TIME ZONE. It accepts see syntax. It returns timezone-aware datetime. A typical example: CREATE TABLE events ( id INT, event_time TIMESTAMPTZ DEFAULT NOW() ); INSERT INTO events (event_time) VALUES ('2026-06-06 14:30:00+08'); -- Stored internally as UTC: 2026-06-06 06:30:00+00 SET TIME ZONE 'America/New_York'; SELECT event_time FROM events; -- Shows: 2026-06-06 02:30:00-04 (converted to ET) SET TIME ZONE 'UTC'; SELECT event_time FROM events; -- Shows: 2026-06-06 06:30:00+00 -- AT TIME ZONE conversion: SELECT event_time AT TIME ZONE 'Asia/Tokyo' FROM events; -- Shows in Tokyo time… A close relative is NOW(), which returns the current date and time as a timestamp. A close relative is CURDATE(), which returns the current date without time. A close relative is DATE(), which extracts the date part from a datetime expression.