Timestamp Data Types

timestamp and timestamp with time zone data expresses a date and time in UTC.

Detail	Info
Quick Syntax	`TIMESTAMP '2007-02-01 15:04:05'` `TIMESTAMP WITH TIME ZONE '2007-02-01 15:04:05+06'`
Size	8 bytes
Min value	4713 BC
Max value	294276 AD
Resolution	1 microsecond / 14 digits

For convenience and compatibility with PostgreSQL, timestamptz is accepted as an alias for timestamp with time zone.

Syntax

Field	Use
WITH TIME ZONE	Apply the tz_offset field. If not specified, don’t.
TIMESTAMPTZ	Apply the tz_offset field.
date_str	date_str
time_str	A string representing a time of day in `H:M:S.NS` format.
tz_offset	The timezone’s distance, in hours, from UTC.

timestamp and timestamptz store data in UTC.
The difference between the two types is that timestamptz can read or write timestamps with the offset specified by the timezone. Importantly, timestamptz itself doesn’t store any timezone data; Materialize simply performs the conversion from the time provided and UTC.
Materialize assumes all clients expect UTC time, and does not currently support any other timezones.

You can cast timestamp or timestamptz to:

You can cast the following types to timestamp or timestamptz:

timestamp data supports the following operations with other types.

SELECT TIMESTAMP '2007-02-01 15:04:05' AS ts_v;

        ts_v
---------------------
 2007-02-01 15:04:05

SELECT TIMESTAMPTZ '2007-02-01 15:04:05+06' AS tstz_v;

         tstz_v
-------------------------
 2007-02-01 09:04:05 UTC