[thelist] SQL : A Select statement that works in SQL Server but NOT Oracle ... why ?

Hi there

It seems I have a slight problem.
I am trying to use the same Select statements one these two systems but I
am getting an error.
The Select statement looks like this :
SET DATEFORMAT dmy SELECT * From mytable WHERE TIEINS = '1' AND TIDTIM
BETWEEN '01.01.2001' AND '03.01.2001'

If you could just help me with where I should start looking for possible
errors I would greatly appreciate it.

With thanks in advance,
Oskar Jensson