Re: to_char() accepting invalid dates?

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