SELECT sysdate-date_column
FROM your_table;

This gives you difference in days between date_column and sysdate;

SELECT (sysdate-date_column)*(24*60)
FROM your_table;
gives you get the difference in minutes