Jasen Betts wrote on 18.07.2011 11:23:
>> postgres=> select to_date('20110231', 'yyyymmdd');
>>
>> 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 *very* odd indeed.
> jasen=# select '20110303'::date;
Thanks for the tip, this was more a question regarding _why_ to_char() behaves this way.
Thomas