I tried to get out all data from an oracle where the date field is a timestamp.
This does not work because of the time component in SYSDATE:
SELECT * FROM table WHERE timestamp_col = SYSDATE - 1;