[GENERAL] now() and time zone

2006-10-04 Thread Jean-Christophe Roux
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

Re: [GENERAL] now() and time zone

2006-10-04 Thread Martijn van Oosterhout
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?

Re: [GENERAL] now() and time zone

2006-10-04 Thread Jean-Christophe Roux
Yes you are right, that's what I have just realized; I should be using EDT instead of EST. Sorry for the botherJCR- Original Message From: Martijn van Oosterhout kleptog@svana.orgTo: Jean-Christophe Roux [EMAIL PROTECTED]Cc: pgsql-general@postgresql.orgSent: Wednesday, October 4, 2006

Re: [GENERAL] now() and time zone

2006-10-04 Thread Tom Lane
Jean-Christophe Roux [EMAIL PROTECTED] 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