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

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>)