Postgres Pro
Downloads
Home   >   mailing lists

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

From Joshua Moore-Oliva
Subject Re: now() AT TIME ZONE interval '-5 hours' returns type interval??? -- more info, looks like a postgres bug
Date
Msg-id 200303132045.53753.josh@chatgris.com
Whole thread Raw
In response to now() AT TIME ZONE interval '-5 hours' returns type interval???  (Joshua Moore-Oliva <josh@chatgris.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Joshua Moore-Oliva
Date:
Subject: now() AT TIME ZONE interval '-5 hours' returns type interval???
Next
From: Andres Montiel
Date:
Subject: embedding PostgreSQL in a Java application