Re: UUID v7
От | Przemysław Sztoch |
---|---|
Тема | Re: UUID v7 |
Дата | |
Msg-id | 67eb8a02-f35c-af10-1615-afae0f9f7548@sztoch.pl обсуждение исходный текст |
Ответ на | Re: UUID v7 (Aleksander Alekseev <aleksander@timescale.com>) |
Ответы |
Re: UUID v7
|
Список | pgsql-hackers |
timstamptz internally always store UTC.Another question: how did you choose between using TimestampTz and Timestamp types? I realize that internally it's all the same. Maybe Timestamp will be slightly better since the way it is displayed doesn't depend on the session settings. Many people I talked to find this part of TimestampTz confusing.
I believe that in SQL, when operating with time in UTC, you should always use timestamptz.
timestamp is theoretically the same thing. But internally it does not convert time to UTC and will lead to incorrect use.
--
Przemysław Sztoch | Mobile +48 509 99 00 66
Przemysław Sztoch | Mobile +48 509 99 00 66
В списке pgsql-hackers по дате отправления: