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
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
