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

Поиск
Список
Период
Сортировка
От Emi Lu
Тема When it is better to use "timestamp without time zone"?
Дата
Msg-id 43BAF423.2020703@cs.concordia.ca
обсуждение исходный текст
Ответы Re: When it is better to use "timestamp without time zone"?  (Michael Glaesemann <grzm@myrealbox.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Moving Tablespaces
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: When it is better to use "timestamp without time zone"?