get data from yesterday

[hpeter]

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;

[hpeter]

For those interested I got it myself:

SELECT * FROM table WHERE to_date(timestamp_col, 'DD.MM.YY') = to_date(SYSDATE, 'DD.MM.YY')-1;