Andrew - Supernews <[EMAIL PROTECTED]> writes: > On 2005-03-04, Bret Hughes <[EMAIL PROTECTED]> wrote: >>> (Why are you using timestamp without time zone anyway? For recording the >> >> Valid question. Because there is no reason to keep up with time zones
> It's a common mistake to think that just because you don't need to keep > track of time zones that somehow using timestamp without time zone is > correct. It is _not_. "timestamp with time zone" and "timestamp without > time zone" have _very_ different semantics. > [ excellent example snipped ] It's curious that people who say they want Unix timestamps find it so hard to wrap their heads around this, because in fact "timestamp with time zone" operates EXACTLY the way that Unix timekeeping is done. Consider this: $ export TZ=GMT $ date Fri Mar 4 15:11:31 GMT 2005 $ export TZ=EST5EDT $ date Fri Mar 4 10:11:35 EST 2005 The system's internal idea of the time didn't change (modulo the few seconds it took to type the commands), but the way it is displayed changed. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq