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@ulstu.ru]
> Sent: Wednesday, July 28, 2004 1:30 PM
> To: pgsql-hackers-win32@postgresql.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@ulstu.ru
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>