client_timezone to server_timezone and reverse

From: silly sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: client_timezone to server_timezone and reverse
Date: 2010-03-05 11:45:01
Message-ID: 4B90EEBD.8070100@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

HELO

i am looking for strange things:
a timezone conversion AS transparent AS a charset encoding conversion are.

for __example__ (not intending to override the current behavior)

i want to see now()::timestampTZ always the same
(the server side time with the timezone predefined firmly)

and to see now()::timeztamp calculated according to the client_timezone
setting whatever the user set it to.

In addition to the current behavior it whould be NICE to
cast timestamTZ to timestamp taking in account a shift between server
and client time, if client specified his TZ.

Browse pgsql-sql by date

  From Date Subject
Next Message Plugge, Joe R. 2010-03-05 13:58:28 Re: [SQL] PostgreSQL Active-Active Configuration
Previous Message Devrim GÜNDÜZ 2010-03-05 08:25:05 Re: PostgreSQL Active-Active Configuration