Re: Validity check in to_date? - Mailing list pgsql-sql

From Alexander M. Pravking
Subject Re: Validity check in to_date?
Date
Msg-id 20031202103615.GH87728@dyatel.antar.bryansk.ru
Whole thread Raw
In response to Re: Validity check in to_date?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-sql
On Tue, Dec 02, 2003 at 10:57:14AM +0100, Karel Zak wrote:
> > > If not, has something changed in 7.4?
> 
>  No change in 7.4. Maybe in 7.5 or in some 7.4.x.

Well, let's see.

>  The others PostgreSQL stuff which full parse (means check ranges)
>  date/time is less optimistic with this:
> 
>  # select '31.11.2003'::date;
>  ERROR:  date/time field value out of range: "31.11.2003"

Exactly! But date_in formats are too limited and "floaty", especially
in 7.3 or less.


-- 
Fduch M. Pravking


pgsql-sql by date:

Previous
From: "Alexander M. Pravking"
Date:
Subject: Re: Validity check in to_date?
Next
From: "Iain"
Date:
Subject: Re: Validity check in to_date?