Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, August 1, 2017

How to I convert this code from Oracle to SQL Server?

SQLServerCentral » Latest topics
How to I convert this code from Oracle to SQL Server?

I haven't been able to successfully update this code.

Oracle
REPLACE(TO_CHAR(PRAC.DATE_OF_BIRTH,'MM-DD-YYYY'),'-','/') AS DOB,

SQL Server
REPLACE(CAST(PRAC.DATE_OF_BIRTH AS DATE ['MM-DD-YYYY']),'-','/') AS DOB,

Thanks i

No comments: