A bozo's blog
SELECT (TO_DATE(
'26/10/2012 12:34:14'
,
'dd/mm/yyyy hh24:mi:ss'
) - TO_DATE(
'01/01/1970'
'dd/mm/yyyy'
)) * 86400 FROM DUAL;