Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need Help decoding a to_date(ed) character field

Re: Need Help decoding a to_date(ed) character field

From: Kaboel Karso <kaboel_at_wau.mis.ah.nl>
Date: 1998/01/16
Message-ID: <34c87e8f.28045637@waubel.wau.mis.ah.nl>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US