Re: Illegal date format...

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Wed, 18 Sep 2002 06:19:02 GMT
Message-ID: <3D881A68.AE7C9537@mailhost.det.ameritech.net>

Eddie wrote:
>
> 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

No you DID NOT!!! the date format you specified in your query would have returned 00-DEC-0000. You obviously created this result set. Quit wasting our time.

-- 
Andrew Allen
Livonia, MI
E- Mailto:ajalle_at_ameritech.net

Received on Wed Sep 18 2002 - 01:19:02 CDT