Oracle to sql

Oracle to sql

am 19.11.2007 19:22:56 von PaulO

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!