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

At sqlplus:
First, select sysdate from dual;
Second, select test_dt from fams_test where test_ctr='CL'.

Compare the two formats. Are they the same?

bjin

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
Received on Mon Mar 15 1999 - 01:57:24 CST