Re: time stamp - Mailing list pgsql-admin

From Tom Lane
Subject Re: time stamp
Date
Msg-id 19877.1024672442@sss.pgh.pa.us
Whole thread Raw
In response to Re: time stamp  (Felipe Nascimento <Felipe.Nascimento@multivalor.com.br>)
List pgsql-admin
Felipe Nascimento <Felipe.Nascimento@multivalor.com.br> writes:
> let's imagine that my server resides in Time Zone(TZ) "-00", and one user
> resides in TZ "-05". Let=B4s say that 12p.m. to the user is 3p.m. to the
> server, on the same day.

> Let's say that the user inputs a date for a business meeting: "2002-06-20
> 12:00:00". The server will save "2002-06-20 12:00:00-00"??

No, it won't.  If the user has TimeZone set to -05, as he should, then
his input of '2002-06-20 12:00:00' will be read as '2002-06-20 12:00:00-05'.
And it will be displayed to him that way.  But if someone else who
has TimeZone set differently looks at the stored value, it will be shown
to them properly converted into their timezone.

This all works exactly the same as ordinary Unix timekeeping --- in
essence, everything is GMT inside the system, and rotation into a
particular timezone happens on-the-fly when a timestamp value is
entered or displayed.  The TimeZone variable corresponds to the TZ
environment variable of Unix.

> My question is: how to manage this so I can send the email to the user at
> his 11 o'clock (8 a.m. server time)???=20

If you let the system do what it wants to do, it will do the right
thing.

            regards, tom lane

pgsql-admin by date:

Previous
From: Felipe Nascimento
Date:
Subject: Re: time stamp
Next
From: "Luis Andaluz P,"
Date:
Subject: Incredible..