Postgres Pro
Downloads
Home   >   mailing lists

Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE - Mailing list pgsql-general

From Tom Lane
Subject Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE
Date
Msg-id 9718.1131640097@sss.pgh.pa.us
Whole thread Raw
In response to TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE  (juleni@livetrade.cz)
List pgsql-general
Tree view 
juleni@livetrade.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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: TIMESTAMP vs TIMESTAMP WITHOUT TIME ZONE
Next
From: "Andrus"
Date:
Subject: Re: Best way to use indexes for partial match at