[thelist] Oracle SELECT question !

[Óskar K Jensson]

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