From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Yuri B(dot) Lukyanov" <snaky(at)ulstu(dot)ru>, <pgsql-hackers-win32(at)postgresql(dot)org> |
Subject: | Re: now() |
Date: | 2004-07-28 11:34:24 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE34BF54@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Klemke | 2004-07-28 12:08:18 | Re: win32 pgsql not installable |
Previous Message | Yuri B. Lukyanov | 2004-07-28 11:29:43 | now() |