Re: now()

What does
SHOW timezone

show? Has it picked up the correct timezone?
If not, try setting the timezone in postgresql.conf and restart the database.

//Magnus

> -----Original Message-----
> From: Yuri B. Lukyanov [mailto:snaky(at)ulstu(dot)ru]
> Sent: Wednesday, July 28, 2004 1:30 PM
> To: pgsql-hackers-win32(at)postgresql(dot)org
> Subject: [pgsql-hackers-win32] now()
>
> sorry for my english.
>
> I have a problem with date/time function now().
> When I run "SELECT now()" query, I get result less than local
> system time (localtime - 1 hour). I understand it concerned
> with daylight-saving, but I cann't understand why postgresql
> take no account of it.
>
>
> ___________________________________
> Best regards, Yuri B. Lukyanov
> 28 июля 2004 г. 15:15:03
> mailto:snaky(at)ulstu(dot)ru
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>