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
![0683p000009M9p6.png 0683p000009M9p6.png](/t5/image/serverpage/image-id/134116iFBD5D7F21624A744/image-size/large?v=v2&px=999)
S') +(
1425148200000 / 1000 / 60 / 60 / 24) FROM Dual;
O/P - 28-FEB-15 (Oracle Format)