[thelist] Oracle SELECT question !

Dean Mah dsmah at home.com
Fri Jul 27 13:01:41 CDT 2001


I think the TO_DATE function takes two parameters, the date and the
format mask.  Try something like:

   TO_DATE('01.01.2000', 'DD.MM.YYYY') AND TO_DATE('27.10.2000', 'DD.MM.YYYY')

Dean


Óskar K Jensson writes:

> 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




More information about the thelist mailing list