Re: time stamp

Thomas Swan <tswan@idigx.com> writes:
>> 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.

If the webserver sets its session TimeZone according to the end user's
preference, everything will work just fine.  I am not sure how you
expect Postgres to intuit the proper timezone to use in this scenario
without any cooperation from the webserver...

            regards, tom lane