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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01839: date not valid for month specified

Re: ORA-01839: date not valid for month specified

From: <afilonov_at_pro-ns.net>
Date: Tue, 16 Mar 1999 02:06:40 GMT
Message-ID: <7ckeb9$19s$1@nnrp1.dejanews.com>


You sure have at least one record which cannot be converted into date in test_dt. It actually a bad habit to keep date type data in character columns. Check if all dates in test_dt are valid and not null (not sure how this conversion will work with null).

In article <7ci6o1$1bc$1_at_nnrp1.dejanews.com>,   hpcheong_at_ncs.com.sg wrote:
> hi all, One funny problem arises while testing in my dev inatance. I tried to
> retrieve 'CL' records from a table with date as one of the comparsion
> criteria. It returns an error even though records exists. Then I tried with
> another record 'BD' with the same sql and it works.
>
> This was strange as it happen to a specific record type - 'CL'. Further
> investigation was done at uat instance and the same sql for 'CL' records was
> tried out. It retrieves record of the specified date!
>
> See below for the actual run at sqlplus :-
>
> SQL> select test_no from fams_test where test_ctr='CL' and
> (to_date(test_dt) = to_date('04/03/1999', 'dd/mm/yyyy'));
>
> pls help, thanks!
>
> evelyn.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 20:06:40 CST

Original text of this message

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