ORA-01839: date not valid for month specified

From: <hpcheong_at_ncs.com.sg>
Date: Mon, 15 Mar 1999 05:44:34 GMT
Message-ID: <7ci6o1$1bc$1@nnrp1.dejanews.com>

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 Sun Mar 14 1999 - 23:44:34 CST