Hi,
Yes i have tried this in many more jobs & it gives expected outcome.
even before this i have converted Dates into milliseconds.. & in MM/DD/YYYY format as well.
I got one SQL query which converts milliseconds into Date in given format. Please look into that..
Select To_Date('01/01/1970 00:00:00', 'DD/MM/YYYY HH24:MI
S') +(
1425148200000 / 1000 / 60 / 60 / 24) FROM Dual;
O/P - 28-FEB-15 (Oracle Format)