How do I convert a SQL Server Date MM/DD/CCYY to an Oracle Date formatted as NUMBER(8,0)

Hi ITBobbyp,

For SQL Server 2012 and above, you can use FORMAT.

SELECT FORMAT(CAST('04/01/2015' AS DATE),'yyyyMMdd') AS DT

/*
DT
20150401
*/

If you have any question, feel free to let me know.

---

Eric Zhang
TechNet Community Support