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

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 31 Jul 2000 16:38:07 -0400
Message-Id: <10575.113413@fatcity.com>

correct. The NLS format has to be set to the format that you are using in = the select or you have to use the to_date function. Ron Rogers
DBA
Atl.GA

>>> Sandeep.Kurliye_at_almarai.com 07/31/00 04:22PM >>>

If I am not wrong then we can set NLS_DATE_FORMAT=3D'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]=20
	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 =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=20

	>

	> 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


	--=20
	Author: Rustem Valeev
	  INET: valeev_at_avicomp.ru=20

	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=3D1=20
	--=20
	Author:=20
	  INET: avdhesh_at_usa.net=20

	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)=

.
--=20
Author: Sandeep Kurliye
  INET: Sandeep.Kurliye_at_almarai.com=20

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 - 15:38:07 CDT