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 по дате отправления