Re: Date Format Inquiry - Mailing list pgsql-general

pgsql-general@commandprompt.com wrote:

> In fact, it shows up correctly up until after I try to specify past
> january, but above the 31st day 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? ;)

select '1999.032'::DATE;

still works and is probably more sound........

Allan.