select sysdate, ROUND(TO_NUMBER(sysdate - to_date('2011-10-12 14:23:00','YYYY-MM-DD hh24:mi:ss')) * 24 * 60) from dual;