Searching on a date

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Wed, 28 Feb 2001 16:23:31 +1100
Message-ID: <JW%m6.5162$v5.18574@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 Tue Feb 27 2001 - 23:23:31 CST