Any reason why this SQL string does not work on Oracle ?
SELECT * From kestjori.vatnshaed_web WHERE TIEINS = '1' AND TIDTIM BETWEEN
To_Date('01.01.2000') AND To_Date('27.10.2000');
TIEINS is of the datatype NUMBER(3)
TIDTIM is of the datatype DATE
I am getting this error :
SQLException: [ORACLE][ODBC Oracle Driver][Oracle OCI] ORA-00911: invalid
character
With thanks in advance,
Oskar Jensson