cast (date as int)??

[padders]

Looks like SQL Server is returning days since 01/01/1900, so I think you would just adjust for the difference between that and Julian Date base, e.g.

SELECT TO_NUMBER (TO_CHAR (:some_date, 'J')) - 2415021
FROM   dual;