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.
signature.asc
Description: Digital signature
