Message-Id: <10563.112456@fatcity.com> From: avdhesh@usa.net Date: 19 Jul 00 14:50:25 MDT Subject: 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 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@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@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@avicomp.ru, (095)4360496 -- = Author: Rustem Valeev INET: valeev@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@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" 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@Kosa.com ------_=_NextPart_001_01BFF1C3.22599078 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: OFF-TOPIC Loose and lose

From ComputerWorld's Shark Tank...

___________________________________________________________

          &nb= sp;       COMPUTERWORLD DAILY = SHARK
          &nb= sp;           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@Kosa.com

------_=_NextPart_001_01BFF1C3.22599078-- ------------------------------ From: Brian_McQuillan@gelco.com Date: Wed, 19 Jul 2000 17:02:07 -0400 Subject: RE: OFF-TOPIC Loose and lose > 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." on 07/19/2000 05:18:29 PM Please respond to ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L 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