Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they ...

-- Get the session time zone. -- Find the next week’s date from SYSDATE. -- SELECT SYSDATE+7 AS NEXTWEEK_DATE FROM DUAL -- Subtract 17 days from SYSDATE. -- SELECT SYSDATE-17 AS 17DAYSBACK FROM DUAL - ...