Re: checking date format with postgresql without creating - Mailing list pgsql-general

Thanks. I notice that this method is not SQL compliant and thus
is not portable to other DBMSs.

Thanks,

Neil

On Tue, 20 Nov 2001, Alvaro Herrera wrote:

> On Mon, 19 Nov 2001, Neil Zanella wrote:
>
> > Hello,
> >
> > I would like to be able to check whether some date is a valid date by
> > asking postgresql? Is this possible?
>
> Sure:
>
> alvherre=> select '28 feb 2001'::date;
>     date
> ------------
>  2001-02-28
> (1 row)
>
> alvherre=> select '29 feb 2001'::date;
> ERROR:  Bad date external representation '29 feb 2001'
>
> You don't need a table to do it.
>
> --
> Alvaro Herrera (<alvherre[@]atentus.com>)
>