Re: Date format issue

On Thu, 18 Mar 2004, Raman wrote:

> In my query of time zone i have details of interval with me like '-9:00',
> '+5:30' etc
>
> my problem is regarding the format of Date which i receive... ie. when I add
> the interval field the results are like:
> Query:
> select current_date at TIME ZONE "interval" '+5:30';
>       timezone
>        11399908 years 8 mons 1538 days

You didn't say what version you're using, but IIRC, there was a bug which
caused the above sort of behavior.  I think it was fixed in 7.4 and could
be fixed in 7.3.x with a catalog change which you might be able to find in
the archives.