SELECT (TO_DATE('03-JUN-2016 20:23:06', 'DD-MM-YYYY HH24:MI:SS') - TO_DATE('01-JAN-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 * 1000 FROM DUAL| (TO_DATE('03-JUN-201620:23:06','DD-MM-YYYYHH24:MI:SS')-TO_DATE('01-JAN-197000:00:00','DD-MM-YYYYHH24:MI:SS'))*24*60*60*1000 | 1464985386000 |
|---|