Re: PostgreSQL now() function returns incorrect time

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