Timestamp vs timestamptz

Поиск
Список
Период
Сортировка
Искать
От
Antimon
Тема
Timestamp vs timestamptz
Дата
Msg-id
1152833720.825665.47040@35g2000cwc.googlegroups.com
Список
Дерево обсуждения
Timestamp vs timestamptz "Antimon" <antimon@gmail.com>
Re: Timestamp vs timestamptz David Fetter <david@fetter.org>
Re: Timestamp vs timestamptz Agent M <agentm@themactionfaction.com>
Re: Timestamp vs timestamptz Florian Weimer <fweimer@bfk.de>
Re: Timestamp vs timestamptz Tom Lane <tgl@sss.pgh.pa.us>
Re: Timestamp vs timestamptz Florian Weimer <fweimer@bfk.de>
Re: Timestamp vs timestamptz Michael Glaesemann <grzm@seespotcode.net>
Re: Timestamp vs timestamptz Martijn van Oosterhout <kleptog@svana.org>
Re: Timestamp vs timestamptz "Antimon" <antimon@gmail.com>
Hi,
I'm working on a web project with pgsql, i did use mysql before and
stored epoch in database so i'm not familiar with these datatypes.

What i wanna ask is, if i don't need to display timestamps in different
timezones, shall i use timestamptz anyway? I mean, i'm gonna need
timestamp columns on some tables for internal calculations and stuff
like delaying actions, adding a row with a timestamp of 10 minutes
later and check for them every minute, fetch elapsed ones and process,
not to display them to users.

Will there be any advantages of using timestamptz type for this? I
thought, only if i move the website to some other server with another
timezone or something, all my timestamps and delayed actions would
still be accurate to the system clock..

Shall i just use timestmap type or timestamptz for this? 

Thanks.

В списке pgsql-general по дате отправления
От: Ron Johnson
Дата:
От: Jamie Deppeler
Дата:
Сообщение: Function Help
FAQ