Timestamp vs timestamptz

From: "Antimon" <antimon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Timestamp vs timestamptz
Date: 2006-07-13 23:35:20
Message-ID: 1152833720.825665.47040@35g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2006-07-13 23:43:13 apparent wraparound
Previous Message Ron Johnson 2006-07-13 22:16:27 Re: Is there a way to run tables in RAM?