SEO

#1 (**permalink**) 04-09-2008, 11:41 AM

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 eastcoast? Can it be that the server where the PostgreSQL database is located is not properly configured?
Many thanks
Jean

#2 (**permalink**) 04-09-2008, 11:41 AM

On Wed, Oct 04, 2006 at 02:01:18PM -0700, Jean-Christophe Roux wrote:
> 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?

Maybe there's summar time/daylight savings time? I'm unsure if "EST" is
supposed to reflect that.

You can say things like:

select now() at time zone 'America/California';

Perhaps that gets you something more reasonable?

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFJCJiIB7bNG8LQkwRAsY3AKCFEXGGUsWrRxRRq9bWnY D7oOCJvACfcJf5
cvxmJo5PBVjpFEuOtnPAn2A=
=qCRH
-----END PGP SIGNATURE-----

#3 (**permalink**) 04-09-2008, 11:41 AM

Jean-Christophe Roux <jcxxr@yahoo.com> writes:
> 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?

USA east coast is currently on EDT ... not EST.

In PG 8.1 and later you can say AT TIME ZONE 'EST5EDT' or
AT TIME ZONE 'America/New_York' to get the behavior I think you are
after.

regards, tom lane

---------------------------(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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

now() and time zone