| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Re: ORA-1839 Date not valid for month specified]
Hi Rustem,
Yaa you will get error since data is a date type column and '29-FEB-1996'=
is a
string. so in where clause you need to convert this string into date usin=
g
to_date function and it should work
data =3D to_date ('29-FEB-1996','DD-MON-YYYY')
again here you should specify right date format.
Thanks
Avdhesh
Rustem Valeev <valeev_at_avicomp.ru> wrote: Check NLS_LANG. Or use '29.02.1996'
Cale, Rick T (Richard) wrote:
> Oracle 8.0.5.1 on NT 4 SP5
>
> I am getting the subject error in a select statement for the
> data=3D'29-FEB-1996'
> Looks like a valid date to me. Any one have any ideas what may be
> happening?
>
> Thanks
> Rick
>
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Rustem Valeev, valeev_at_avicomp.ru, (095)4360496 -- = Author: Rustem Valeev INET: valeev_at_avicomp.ru Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1 ------------------------------ From: "Bowes, Chris" <Chris.Bowes_at_kosa.com> Date: Wed, 19 Jul 2000 16:51:37 -0400 Subject: RE: OFF-TOPIC Loose and lose This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFF1C3.22599078 Content-Type: text/plain; charset="iso-8859-1" ------------------------------ From ComputerWorld's Shark Tank... ___________________________________________________________ COMPUTERWORLD DAILY SHARK July 19, 2000 ___________________________________________________________ Shark Tank: Sometimes even computers make misteaks Secretary assiduously spell-checks each and every document she handles, but still becomes "notorious for misspellings in the documents she transcribed," says this network admin pilot fish. So the fish dons his deerstalker to play Sherlock and solves the first mystery -- in the secretary's word processor, her personal dictionary is full of misspelled words. Fish asks secretary if she knows how they got there. Oh, yes, she answers. "When I spell-check, sometimes the computer gives the wrong answer, so I add the correct spelling to my personal dictionary." --Chris Chris.Bowes_at_Kosa.com ------_=_NextPart_001_01BFF1C3.22599078 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: OFF-TOPIC Loose and lose</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>From ComputerWorld's Shark Tank...</FONT> </P> <P><FONT = SIZE=3D2>___________________________________________________________</FO= NT> </P> <P><FONT = SIZE=3D2> &nb= sp; COMPUTERWORLD DAILY = SHARK</FONT> <BR><FONT = SIZE=3D2> &nb= sp; July = 19, 2000</FONT> <BR><FONT = SIZE=3D2>___________________________________________________________</FO= NT> </P> <BR> <BR> <P><FONT SIZE=3D2>Shark Tank: Sometimes even computers make = misteaks</FONT> </P> <P><FONT SIZE=3D2>Secretary assiduously spell-checks each and every = document she handles, but</FONT> <BR><FONT SIZE=3D2>still becomes "notorious for misspellings in = the documents she transcribed,"</FONT> <BR><FONT SIZE=3D2>says this network admin pilot fish.</FONT> </P> <P><FONT SIZE=3D2>So the fish dons his deerstalker to play Sherlock and = solves the first mystery</FONT> <BR><FONT SIZE=3D2>-- in the secretary's word processor, her personal = dictionary is full of</FONT> <BR><FONT SIZE=3D2>misspelled words.</FONT> </P> <P><FONT SIZE=3D2>Fish asks secretary if she knows how they got = there.</FONT> </P> <P><FONT SIZE=3D2>Oh, yes, she answers. "When I spell-check, = sometimes the computer gives the</FONT> <BR><FONT SIZE=3D2>wrong answer, so I add the correct spelling to my = personal dictionary."</FONT> </P> <BR> <P><FONT SIZE=3D2>--Chris</FONT> <BR><FONT SIZE=3D2>Chris.Bowes_at_Kosa.com</FONT> </P> </BODY> </HTML> ------_=_NextPart_001_01BFF1C3.22599078-- ------------------------------ From: Brian_McQuillan_at_gelco.com Date: Wed, 19 Jul 2000 17:02:07 -0400 Subject: RE: OFF-TOPIC Loose and loseReceived on Wed Jul 19 2000 - 15:50:25 CDT
> Is it a disk drive or a disc drive?
Hmmmmm , i suppose this one depends which flavour (note the spelling) of English you learned. I still find it strange, even after living in the States for 18 months (I'm originally from Scotland) to see the lack of the letter 'u' in certain words like colour , flavour and so on. Also there's the 'er' / 're' mixup as well, with 'center' instead of 'centre' etc Though, when I'm down on Broadway in NYC they can't seem to make up their minds on how to spell 'theatre', some say 'theatre' and some say 'theater' go figure ! Brian "Smith, Ron L." <rlsmith_at_kmg.com> on 07/19/2000 05:18:29 PM Please respond to ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Brian McQuillan/GELCO) Subject: RE: OFF-TOPIC Loose and lose Is it a disk drive or a disc drive? -----Original Message----- Sent: Wednesday, July 19, 2000 3:14 PM To: Multiple recipients of list ORACLE-L
 |
 |