Search Postgresql Archives

now() and time zone

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

To: pgsql-general@xxxxxxxxxxxxxx
Subject: now() and time zone
From: Jean-Christophe Roux <jcxxr@xxxxxxxxx>
Date: Wed, 4 Oct 2006 14:01:18 -0700 (PDT)

Hello,
I am a bit sorry to come back on that topic but I just cannot get it right. How comes that
select now() at time zone 'EST'
returns
"2006-10-04 15:59:26.713623"
when it is actually 16:59 on the east coast? Can it be that the server where the PostgreSQL database is located is not properly configured?
Many thanks
Jean

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

Follow-Ups:
- Re: now() and time zone
  - From: Tom Lane
- Re: now() and time zone
  - From: Martijn van Oosterhout

Prev by Date: Re: Storing images in PostgreSQL databases (again)
Next by Date: Re: now() and time zone
Previous by thread: [Fwd: Realizing the Value of Enterprise Open Source Databases] -- May be of interest -- re Sony Online's use of Enterprise DB
Next by thread: Re: now() and time zone
Index(es):
- Date
- Thread

[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