Re: Illegal date format...

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Wed, 18 Sep 2002 08:26:10 +0200
Message-ID: <uog7dk1j9lvr51@corp.supernews.com>

IMHO the output you show (full month name) cannot be caused by the to_char data format model (dd-mon-yyyy).

Peter

"Eddie" <shuler_at_ntelos.net> schreef in bericht news:31c10b07.0209171224.7def9f87_at_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 Wed Sep 18 2002 - 01:26:10 CDT