Oracle 10 Gb time processing (2)

 

-- Add one minute to the specified time

SELECT to_char (to_date ('2017-11-09 15:30:30 ', 'yyyy-MM-DD HH24: MI: ss') + (2011), 'yyyy-MM-DD HH24: MI: SS ') as newDate FROM dual;

 

 

-- Subtract two times

Select to_date ('2017-11-09 15:30:30 ', 'yyyy-MM-DD HH24: MI: ss')-to_date ('2017-10-09 15:30:30 ', 'yyyy/MM/DD HH24: MI: ss') from dual

 

 

-- Minus 10 minutes

Select sysdate, sysdate-interval '10' minute as "Current Time-10 minutes" from dual;

-- Result: 5:09:34, 4:59:34

 

 

-- Minus 10 hours

Select sysdate, sysdate-interval '10' hour as "Current Time-10 minutes" from dual;

-- Result: 5:10:59, 7:10:59 AM

 

 

-- Minus 10 days

Select sysdate, sysdate-interval '10' day as "Current Time-10 minutes" from dual;

-- Result: 5:11:42, 5:11:42