Postgres Pro
Downloads
Home   >   mailing lists

TIMESTAMP(TZ) range - Mailing list pgsql-bugs

From Olga Lytvynova-Bogdanova
Subject TIMESTAMP(TZ) range
Date
Msg-id CAK=HMLbSBhD12bNSuHxcC7JNfw8xOrWhW5F2NiLud=RiLN_ruw@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Tree view
Good day,

I want to ask about the TIMESTAMP(TZ) type limits. According to the dosc, the minimum value is 4713 BC. It seems that I can insert a lower value than 4713-01-01 00:00:00 BC, for instance, 4714-11-24 00:00:00 BC. Could you please confirm the limits we should refer to?

Best regards
Olga

pgsql-bugs by date:

Previous
From: Olav Gjerde
Date:
Subject: Re: BUG #15294: Phantom read in serializable transaction when yourename schema.
Next
From: Ze Victor Harry
Date:
Subject: pgAdmin 4 not opening