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;
Printable View
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;
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;