Re: now() AT TIME ZONE interval '-5 hours' returns type interval??? -- more info, looks like a postgres bug

From: Joshua Moore-Oliva <josh(at)chatgris(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: now() AT TIME ZONE interval '-5 hours' returns type interval??? -- more info, looks like a postgres bug
Date: 2003-03-14 01:45:53
Message-ID: 200303132045.53753.josh@chatgris.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In addition, if I use

SELECT now() AT TIME ZONE 'EST' It remains as type timezone...

This looks like a bug in Postgres.. since the manual mentions that you can
'EST' and interval '-5 hours' interchangeably.

Anyone agree//disagree before I post a bug report? I'm rather new to postgres
implementation of a timestamp so I'd rather get some feedback (hoping I'm
wrong ) before I submit a bgu report..

Josh.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-03-14 02:17:03 Re: removal from list
Previous Message Joshua Moore-Oliva 2003-03-14 01:37:47 now() AT TIME ZONE interval '-5 hours' returns type interval???