RE: [Re: ORA-1839 Date not valid for month specified]

From: Sandeep Kurliye <Sandeep.Kurliye_at_almarai.com>
Date: Mon, 31 Jul 2000 22:01:08 +0300
Message-Id: <10575.113407@fatcity.com>

If I am not wrong then we can set NLS_DATE_FORMAT='DD-MON-YYY' in Server Registry, Init.ora and Client Registry.

After that Oracle will take '29-FEB-1996' as valid date.

DBAs, correct me if I am wrong.

Sandeep.

	-----Original Message-----
	From:	avdhesh_at_usa.net [SMTP:avdhesh_at_usa.net]
	Sent:	Thursday, July 20, 2000 3:25 AM
	To:	Multiple recipients of list ORACLE-L
	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 using

        to_date function and it should work

        data = 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='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=1
	-- 
	Author: 
	  INET: avdhesh_at_usa.net

	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

Received on Mon Jul 31 2000 - 14:01:08 CDT