SELECT col1, col2, ... FROM table1 where date_col <>
to_date('29/DEC/1899','DD/MON/YYYY');
--
zhaoyaojun
"Peta Griffith" <peta_at_dataspeed.com.au> wrote in message
news:JW%m6.5162$v5.18574_at_newsfeeds.bigpond.com...
> We are using the Oracle ODBC driver and Visual Basic and are trying either
> of the 2 following statements :
>
> Statement 1:
>
> SELECT CO02DATA.TBLBPSTUDENTS.STUDENT_NUMBER,
> CO02DATA.TBLBPSTUDENTS.SCHOOL_NUMBER, CO02DATA.TBLBPSTUDENTS.SURNAME,
> CO02DATA.TBLBPSTUDENTS.CHRISTIAN_NAMES,
> CO02DATA.TBLBPSTUDENTS.DATE_OF_ADDRESS_CHANGE,
> CO02DATA.TBLBPSTUDENTS.CURR_ADDRESS1,
CO02DATA.TBLBPSTUDENTS.CURR_ADDRESS2,
> CO02DATA.TBLBPSTUDENTS.CURR_NO_OF_SECTIONS1,
> CO02DATA.TBLBPSTUDENTS.CURR_NO_OF_SECTIONS2,
> CO02DATA.TBLBPSTUDENTS.LAST_ADDRESS1,
CO02DATA.TBLBPSTUDENTS.LAST_ADDRESS2,
> CO02DATA.TBLBPSTUDENTS.YEAR_OF_ADDRESS_CHANGE,
> CO02DATA.TBLBPSTUDENTS.SEMESTER_OF_ADDRESS_CHANGE FROM
> CO02DATA.TBLBPSTUDENTS WHERE
(CO02DATA.TBLBPSTUDENTS.DATE_OF_ADDRESS_CHANGE)
> <> '29/DEC/1899'
>
> Statement 2:
>
> SELECT CO02DATA.TBLBPSTUDENTS.STUDENT_NUMBER,
> CO02DATA.TBLBPSTUDENTS.SCHOOL_NUMBER, CO02DATA.TBLBPSTUDENTS.SURNAME,
> CO02DATA.TBLBPSTUDENTS.CHRISTIAN_NAMES,
> CO02DATA.TBLBPSTUDENTS.DATE_OF_ADDRESS_CHANGE,
> CO02DATA.TBLBPSTUDENTS.CURR_ADDRESS1,
CO02DATA.TBLBPSTUDENTS.CURR_ADDRESS2,
> CO02DATA.TBLBPSTUDENTS.CURR_NO_OF_SECTIONS1,
> CO02DATA.TBLBPSTUDENTS.CURR_NO_OF_SECTIONS2,
> CO02DATA.TBLBPSTUDENTS.LAST_ADDRESS1,
CO02DATA.TBLBPSTUDENTS.LAST_ADDRESS2,
> CO02DATA.TBLBPSTUDENTS.YEAR_OF_ADDRESS_CHANGE,
> CO02DATA.TBLBPSTUDENTS.SEMESTER_OF_ADDRESS_CHANGE FROM
> CO02DATA.TBLBPSTUDENTS WHERE
(CO02DATA.TBLBPSTUDENTS.DATE_OF_ADDRESS_CHANGE)
> <> TO_DATE('29/DEC/1899')
>
> We are getting the error message :
>
> 'ORA-01858 Non numeric character was found where a numeric was expected'
>
> for both statements.
>
> Does anyone have any ideas of why this is happening??
>
> Thank you very much.
>
>
Received on Thu Mar 15 2001 - 02:47:30 CST
