client_timezone to server_timezone and reverse

Поиск
Список
Период
Сортировка
От silly sad
Тема client_timezone to server_timezone and reverse
Дата
Msg-id 4B90EEBD.8070100@bankir.ru
обсуждение исходный текст
Список 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.



В списке pgsql-sql по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: [ADMIN] PostgreSQL Active-Active Configuration
Следующее
От: "Plugge, Joe R."
Дата:
Сообщение: Re: PostgreSQL Active-Active Configuration