Bruce Momjian, 20.07.2011 03:03:
>>> Well, to_char() is based on Oracle's to_char(). How does Oracle handle
>>> such a date?
>>
>> Oracle throws an error for the above example:
>>
>> SQL> select to_date('20110231', 'YYYYMMDD') from dual;
>> select to_date('20110231', 'YYYYMMDD') from dual
>> *
>> ERROR at line 1:
>> ORA-01839: date not valid for month specified
>>
>> SQL>
>
> OK, it's a bug then. Let me see if I can find a fix for it.
Thanks for the info. I didn't know it was modelled after the Oracle implementation.
Regards
Thomas