title: oracle query to convert number format to date format or vice versa
body: <p>In DB, date is stored in number format (Mon Jul 07 14:41:40 IST 2014
    is stored as 1404724300383), I need a query to convert number to date to compare with the sysdate, or from sysdate to number format. How can we convert the date to number or vice versa?</p>