[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