Illegal date format...

From: Eddie <shuler_at_ntelos.net>
Date: 17 Sep 2002 13:24:53 -0700
Message-ID: <31c10b07.0209171224.7def9f87@posting.google.com>

I saw it with my own eyes! Webmethods inserted an illegal date into the Oracle database. When I query the table here is what I get. We are running database version 7.3.4. And yes the eta_date_lfdat is a date field in the databse. Has anyone seen this before? Eddie Shuler

  1* select to_char(eta_date_lfdat,'dd-mon-yyyy') from sap_delivery SQL> / TO_CHAR(ETA_DATE_LFDAT,'DD-MON-YYYY')

---

00-december-0000
00-december-0000 Received on Tue Sep 17 2002 - 15:24:53 CDT