Oracle to sql

Hi, can you help me converting some queries from ASP application Oracle to
SQL SERVER 2000?

example:

1) " and p.DATACAD <= to_date('"& BDATACAD2 &" 23:59:59','dd/mm/yyyy
hh24:mi:ss')"

2) " WHERE TO_CHAR(DATA_HORAS,'MM/YYYY') ='"&SEL_PER&"'"

How can it be converted to SQL Server?

Thanks a lot!
PaulO [ Mo, 19 November 2007 19:22 ] [ ID #1874333 ]
Webserver » microsoft.public.inetserver.asp.db » Oracle to sql

Vorheriges Thema: Merging recordsets from two different DBs
Nächstes Thema: File name or class name not found during Automation operation