Subtracting Minutes from SYSDATE
391020Apr 8 2003 — edited Apr 8 2003Hi there,
I am trying to create SQL that selects/inserts data that is equal to the sysdate minus 15 minutes.
I have tried to do a statement as follows:
SYSDATE - 1
Although this takes off a day.
Does anybody know how to subtract a date by minutes?
Cheers,
CJ