Re: When it is better to use "timestamp without time zone"? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: When it is better to use "timestamp without time zone"?
Date
Msg-id D2CE084B-8521-4A2C-8E51-E66C2593F048@myrealbox.com
Whole thread Raw
In response to When it is better to use "timestamp without time zone"?  (Emi Lu <emilu@cs.concordia.ca>)
Responses Re: When it is better to use "timestamp without time zone"?
List pgsql-general
On Jan 3, 2006, at 16:01 , Emi Lu wrote:

> I need to know when it is better that we use "timestamp without
> time zone" ? And when it is better to use "timestamp with time zone"?

In my opinion, if you want to store a timestamp, you should always
use timestamp with time zone, as the UTC offset information is
necessary to provide a unique timestamp value.

Michael Glaesemann
grzm myrealbox com



pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: When it is better to use "timestamp without time zone"?
Next
From: Greg Stark
Date:
Subject: Re: generic way to retrieve array as rowset