Thursday, April 30, 2015

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

Try ISO style 112 with CONVERT:


--T-SQL
select CONVERT(Char(10),Cast('2015-04-01' as date),112) , CONVERT(Char(10),current_timestamp,112)

No comments:

Post a Comment