When it is better to use "timestamp without time zone"?

From: Emi Lu <emilu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: When it is better to use "timestamp without time zone"?
Date: 2006-01-03 22:01:07
Message-ID: 43BAF423.2020703@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-01-03 22:25:58 Re: When it is better to use "timestamp without time zone"?
Previous Message Tom Lane 2006-01-03 21:13:35 Re: Moving Tablespaces