Re: Time Zone design issues - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Time Zone design issues
Date
Msg-id 20070910153907.GC5112@alvh.no-ip.org
Whole thread Raw
In response to Re: Time Zone design issues  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout escribió:

> The postgres function now() is the same: it returns a number of seconds.
> Only when you actually go to display it does it do the localtime()
> dance (internally) to make it look nice. That why you can set the
> timezone to whatever you like and everything works the same.

FWIW, the equivalent to the TZ variable in Postgres is setting the
TimeZone variable (either using SET at the start of the session, or via
ALTER USER/SET, etc).

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"E pur si muove" (Galileo Galilei)

pgsql-general by date:

Previous
From: novnov
Date:
Subject: Re: Time Zone design issues
Next
From: Alvaro Herrera
Date:
Subject: Re: Checking is TSearch2 query is valid