Cacher is the code snippet organizer for pro developers

--Now	
sysdate

--Tomorrow/Next Day	
sysdate + 1

--Seven Days from Now	
sysdate + 7

--One Hour from Now	
sysdate + 1/24

--Three Hours from Now	
sysdate + 3/24

--Half an Hour from Now	
sysdate + 1/48

--Ten Minutes from Now	
sysdate + 10/1440

--Thirty Seconds from Now	
sysdate + 30/86400

--Tomorrow at 12 Midnight	
trunc(sysdate + 1)

--Tomorrow at 8am	
trunc(sysdate + 1) + 8/24

--Next Monday at 12 Noon	
next_day(trunc(sysdate), 'MONDAY') + 12/24

--First Day of the Month at 12 Midnight	
trunc(last_day(sysdate) + 1)

--The Nex Monday, Wednesday or Friday at 9am	
trunc(least(next_day(sysdate,''MONDAY''),next_day(sysdate,''WEDNESDAY''),next_day(sysdate,''FRIDAY''))) + (9/24)