Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Help decoding a to_date(ed) character field
1999 is not a leap year..
On Fri, 16 Jan 1998 14:29:03 GMT, zook_at_web.com (Zook ) wrote:
>I am trying to perform the following decode statement:
>
>decode(POLICY.APP_DATE,'00000000',to_date('02291999','mmddyyyy'),
>to_date(substr(POLICY.APP_DATE,5,2),substr(POLICY.APP_DATE,7,2),
>substr(POLICY.APP_DATE,1,4)),'mmddyyyy')
>
>
>but I keep getting an error message that says:
>
>"ORA-01821: date format not recognized :-1821"
>
>Can anyone tell me what is wrong with this?
Kaboel Karso
Consultant
\\\|/// \\ ~ ~ // ( @ @ ) ==========================-oOOo-(_)-oOOo-=================== eSCOSYS Consultancy Phone : +31 (0)32 024 7285 Horst 2827 Fax : +31 (0)32 024 7286 8225 MZ Lelystad Mobile : +31 (0)65 498 5413 The Netherlands email : kkarso_at_knoware.nl ==================================-Oooo.-=================== .oooO ( ) ( ) ) / \ ( (_/Received on Fri Jan 16 1998 - 00:00:00 CST