Re: now()

["Magnus Hagander" <mha(at)sollentuna(dot)net>]

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
> 
>