Search Postgresql Archives

Re: PostgreSQL now() function returns incorrect time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux