Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL now() function returns incorrect time

PostgreSQL now() function returns incorrect time

From
"Giovanni M."
Date:
I was wondering if somebody could point me in the right direction.
I'm situated in Brazil and recently daylights savings/summer time kicked in and clocks were set one hour ahead. Now on my windows box the system clock automatically adjusted to the correct time. But performing the following query on the postgresql-8.0 server i get this result:
 
select now()
----------------------
2005-11-09 13:22:27.625-03
 
while the actual current time is 14:22h, and being reported correctly in the windows system clock
 
I have tried finding some information in the documentation and came across locale settings in the postgresql.conf configuration file but Im not sure if this is the correct place to be looking. Should i set the timezone property in postgresql.conf to something other than unknown?
 
any help would be appreciated,
 
giovanni

--
A World of KEIGI
http://keigi.blogspot.com

Re: PostgreSQL now() function returns incorrect time

From
Michael Fuhr
Date:
On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote:
> I'm situated in Brazil and recently daylights savings/summer time kicked in
> and clocks were set one hour ahead. Now on my windows box the system clock
> automatically adjusted to the correct time. But performing the following
> query on the postgresql-8.0 server i get this result:
>  select now()
> ----------------------
> 2005-11-09 13:22:27.625-03
>  while the actual current time is 14:22h, and being reported correctly in
> the windows system clock
>  I have tried finding some information in the documentation and came across
> locale settings in the postgresql.conf configuration file but Im not sure if
> this is the correct place to be looking. Should i set the timezone property
> in postgresql.conf to something other than unknown?

Do you see the correct time if you do the following?

SET timezone TO 'Brazil/East';
SELECT now();

If so then change the timezone line in postgresql.conf to:

timezone = Brazil/East

Then reload or restart the database.

--
Michael Fuhr

Re: PostgreSQL now() function returns incorrect time

From
"Giovanni M."
Date:
I followed your instructions and now() indeed returned the correct time!
Thanks for your help

 
On 11/9/05, Michael Fuhr <mike@fuhr.org> wrote:
On Wed, Nov 09, 2005 at 02:24:28PM -0200, Giovanni M. wrote:
> I'm situated in Brazil and recently daylights savings/summer time kicked in
> and clocks were set one hour ahead. Now on my windows box the system clock
> automatically adjusted to the correct time. But performing the following
> query on the postgresql-8.0 server i get this result:
>  select now()
> ----------------------
> 2005-11-09 13:22:27.625-03
>  while the actual current time is 14:22h, and being reported correctly in
> the windows system clock
>  I have tried finding some information in the documentation and came across
> locale settings in the postgresql.conf configuration file but Im not sure if
> this is the correct place to be looking. Should i set the timezone property
> in postgresql.conf to something other than unknown?

Do you see the correct time if you do the following?

SET timezone TO 'Brazil/East';
SELECT now();

If so then change the timezone line in postgresql.conf to:

timezone = Brazil/East

Then reload or restart the database.

--
Michael Fuhr



--
A World of KEIGI
http://keigi.blogspot.com