| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | novnov <novnovice(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Time Zone design issues |
| Date: | 2007-09-10 15:39:07 |
| Message-ID: | 20070910153907.GC5112@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-09-10 15:40:11 | Re: Checking is TSearch2 query is valid |
| Previous Message | novnov | 2007-09-10 15:34:55 | Re: Time Zone design issues |