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;
Results 1 to 2 of 2
Thread: get data from yesterday
|
|
|