Skip site navigation (1) Skip section navigation (2)

Re: now()

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 (view raw or flat)
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
> 
> 

pgsql-hackers-win32 by date

Next:From: Christian KlemkeDate: 2004-07-28 12:08:18
Subject: Re: win32 pgsql not installable
Previous:From: Yuri B. LukyanovDate: 2004-07-28 11:29:43
Subject: now()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group