Scott Mohekey <scott.mohe...@telogis.com> wrote: > What is the relationship between Timestamp and TimestampTz? TIMESTAMP WITHOUT TIME ZONE does not identify a moment in time without first associating it with a time zone. When Daylight Saving Time ends, the same TIMESTAMP WITHOUT TIME ZONE values will recur, without any way to distinguish them from those from the previous hour. The only use case I have been able to think of, personally, for TIMESTAMP WITHOUT TIME ZONE is a release date for, say a Harry Potter book or World of Warcraft expansion set, where as the given moment arrives in each time zone, stores in that time zone can begin to sell the given work. I suspect there's probably one or two other valid uses, but most uses are just mistakes, waiting to be exposed. For almost every reasonable use, the right data type is TIMESTAMP WITH TIME ZONE. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
