Thomas Kellerer wrote:
> Bruce Momjian, 19.07.2011 00:02:
> postgres=> select to_date('20110231', 'mmdd');
>
> to_date
>
> 2011-03-03
> (1 row)
>
> is there a way to have to_date() raise an exception in such a case?
> >>>
> >>> it'
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: Monday, July 18, 2011 6:02 PM
To: Thomas Kellerer
Cc: pgsql-sql@postgresql.org
Subject: Re: to_char() accepting invalid dates?
Thomas Kellerer wrote:
> Jasen Betts wrote on 18.07.2011 11:23:
> >> postgres=> select t
Bruce Momjian, 19.07.2011 00:02:
postgres=> select to_date('20110231', 'mmdd');
to_date
2011-03-03
(1 row)
is there a way to have to_date() raise an exception in such a case?
it's possible the odd behaviour you get is required by some standard.
That would be *ver
