TIMESTAMP ​

The TIMESTAMP data type stores 8-byte date values that include timestamp information in UTC format but no time zone information. You can load TIMESTAMP columns with time zone information, but the time zone is not stored or returned in query output.

You cannot define a TIMESTAMP column with a specific precision for fractional seconds other than 6. A valid timestamp includes up to 6 digits of precision. If additional fractional digits exist in input values, the timestamp is rounded up or down, as appropriate.

For example, the following CREATE TABLE statements are allowed and produce the same table:

premdb=# create table timestamps6(c1 timestamp(6));
CREATE TABLE

premdb=# create table timestamps(c1 timestamp); 
CREATE TABLE

The following CREATE TABLE statement is disallowed:

premdb=# create table timestamps(c1 timestamp(4));
ERROR:  TIMESTAMP with precision 4 is not allowed, only 6 is supported

The following examples show the behavior when different values are inserted into a TIMESTAMP column. The range of valid dates in timestamps is from 01-01-0001 to 12-31-9999.

Parent topic:SQL Data Types