Re:Working with Postgres Types
by doctor_eval on Monday August 09, 2021 @06:51AM
(#28115057)
Oh ok yep sure, you're right. If you want to keep the timestamp then you need to keep it in both cases.
But with timestamptz you don't need to use the timezone in most calculations while with timestamp you do need to use the timezone otherwise unexpected behaviour can creep in.
But yes I do agree that you're technically correct, and that's the best kind of correct after all :)
But with timestamptz you don't need to use the timezone in most calculations while with timestamp you do need to use the timezone otherwise unexpected behaviour can creep in.
But yes I do agree that you're technically correct, and that's the best kind of correct after all :)