Re: time stamp

Is this valid for Web applications where the db server's client is the web
server? (web server resides on the same machine of the db server!)
Or this is valid only for client x server applications?

Felipe

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: sexta-feira, 21 de junho de 2002 12:14
To: Felipe Nascimento
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] time stamp

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 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