SQL Server Oracle To_Date equivalent
Oracle: SELECT to_date('01-JAN-2009')FROM dual
SQL Server: SELECTCAST('01-JAN-2009'ASDATETIME) Or you can useSELECTCONVERT(DATETIME,'01/JAN/2009')Oracle: SELECT to_date('01-JAN-2009')FROM dual
SQL Server: SELECTCAST('01-JAN-2009'ASDATETIME) Or you can useSELECTCONVERT(DATETIME,'01/JAN/2009')