timestamp Data Type

timestamp and timestamptz data expresses a date and time in UTC.

Syntax 

TIMESTAMP 

TIMESTAMPTZ 

Details 

• 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.

Valid casts 

From timestamp 

You can cast timestamp or timestamptz to:

• string

To timestamp 

You cannot cast timestamp or timestamptz to any other type.

Notably, you also cannot cast between timestamp and timestamptz.

Examples 

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