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

From Emi Lu
Subject When it is better to use "timestamp without time zone"?
Date
Msg-id 43BAF423.2020703@cs.concordia.ca
Whole thread Raw
Responses Re: When it is better to use "timestamp without time zone"?  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
Greetings,

Happy New Year listing!

I have a question about column type timestamp "with time zone" and
"without time zone".
. when data are import/export into different time zones, column
timestamp with time zone is necessary
  For example, "2005-01-01 2001:01:01+05" under timezone1 will still be
saved as "2005-01-01 2001:01:01+05" under different time zones
  Otherwise, "2005-01-01 2001:01:01" means different timestamp under two
different time zones

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"?

Thanks a lot!
Emi





pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Moving Tablespaces
Next
From: Michael Glaesemann
Date:
Subject: Re: When it is better to use "timestamp without time zone"?