| Forum: SQL |
Thema:
to_date(ORACLE) SQL Server |
Von:
Sebastian Fetter (
17.05.2004 12:44) |
Hi I have trouble getting the following Oracle Code to run by SQL Server. The to_date function is not known bei SQL Server.
I tried to write it with cast and convert but still won't get it running.
I would appreciate any help...
[...]
' getting DateAfter...
strDateAfter = request("DayAfter") & "-" & request("MonthAfter") & "-" & request("YearAfter")
strDateBefore = request("DayBefore") & "-" & request("MonthBefore") & "-" & request("YearBefore")
if len(strDateAfter) = 8 and len(strDateBefore) = 8 then
whrDate = " to_date(lease_end_date, 'dd-mm-yy') BETWEEN to_date('" & strDateAfter & "', 'dd-mm-yy') AND to_date('" & strDateBefore & "', 'dd-mm-yy') AND"
[...]
Antworten
Vorsicht bei der Eingabe: Die Zeichen ' oder -- sind nicht erlaubt!
