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