> > However we consider that to_date() exists to be > Oracle compatible, > and so I would regard this as a bug if and only if > Oracle does > something different with the same input. Anyone > know? >
Here is the output I get from Oracle: ===================================================== Connected to: Oracle8 Enterprise Edition Release 8.0.6.3.0 - Production SELECT to_date('2005-02-27', 'YYYY-MM-DD') from dual TO_DATE('2005-02-27','YYYY-MM- ------------------------------ 2/27/2005 1 row selected SELECT to_date('2005-02-29', 'YYYY-MM-DD') from dual ORA-01839: date not valid for month specified SELECT to_date('2005-02-32', 'YYYY-MM-DD') from dual; ORA-01847: day of month must be between 1 and last day of month =========================================== Regards, Shelby Cain __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly