SQL FAQ - Oracle FAQ
Description Date Expression Now SYSDATE Tomorow/ next day SYSDATE + 1 Seven days from now SYSDATE + 7 One hour from now SYSDATE + 1/24 Three hours from now SYSDATE + 3/24 A half hour from now SYSDATE + 1/48 10 minutes from now...