Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: juleni(at)livetrade(dot)cz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE
Date: 2005-11-10 16:28:17
Message-ID: 9718.1131640097@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

juleni(at)livetrade(dot)cz writes:
> I have question about functionality for TIMESTAMP (with/without time zone).
> The main question is, what is better for usage: timemestamp WITH or WITHOUT
> time zone?

You almost certainly want to store timestamp WITH time zone. It's
really poor design that the SQL spec defines plain "timestamp" to mean
the other.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-11-10 16:43:17 Re: Best way to use indexes for partial match at
Previous Message Martijn van Oosterhout 2005-11-10 16:20:41 Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE