From: | Thomas Swan <tswan(at)idigx(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)br>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: time stamp |
Date: | 2002-06-21 17:45:17 |
Message-ID: | 3D13662D.4000803@idigx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tom Lane wrote:
>Felipe Nascimento <Felipe(dot)Nascimento(at)multivalor(dot)com(dot)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 can be a problem if the client is a web application in a fixed
timezone and the person viewing the results is in a different time zone.
>
>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.
>
Another option is to get the timestamp via conversion to abstime to
integer and your script or application format that timestamp (integer)
to local format (string).
mytime::abstime::integer (this should be a GMT timestamp [int] if I
remember correctly).
Someone correct me if I'm wrong.
>
>
>
>>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Davide Bozzelli | 2002-06-21 19:16:06 | Re: lost superuser perms |
Previous Message | Felipe Nascimento | 2002-06-21 17:39:29 | Re: time stamp |