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

[Tab Alleman]

Hehehehehe... I knew as soon as I saw the subject line that this was going
to involve a date field.

When you work with dates in Oracle, you have to use their built-in "ToDate"
function.  It's been a while since I used it, so I'm not going to try to
reproduce the format from memory.. it would probably do more harm than good.
Pull out your handy Oracle SQL reference, and look up "ToDate()"

hth,
Tab

-----Original Message-----

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


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !