Maintained Date Formats - Mailing list pgsql-hackers

From
Subject Maintained Date Formats
Date
Msg-id Pine.LNX.4.30.0108101407590.26185-100000@commandprompt.com
Whole thread Raw
In response to Re: Portal destination issue: binary vs normal cursors  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Good day,

In the on-line documentation, it's mentioned that there is an available
date format of the form YYDDD, where YY is the year, and DDD is the day of
the year.

The example given is '99008', which does show up correctly:

lx=# SELECT date('99008');   date
------------1999-01-08
(1 row)

In fact, it shows up correctly up until I try to specify past
january, when above the 31st day of the year it fails.

lx=# SELECT date('99031');   date
------------1999-01-31
(1 row)

lx=# SELECT date('99032');
ERROR:  Bad date external representation '99032'

Is this format no longer maintained, or am I missing something? ;)


Regards,
Jw.
--
jlx@commandprompt.com
by way of pgsql-hackers@commandprompt.com



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Portal destination issue: binary vs normal cursors
Next
From:
Date:
Subject: Boolean Implicitly Typed?