Addition and subtraction of oracle time

Guidance:ForOracle timeAccording to our actual needsAddition and subtractionComputing. The following describes the addition and subtraction of oracle time in detail. We hope this will help you learn about oracle time.

Addition

Select sysdate, add_months (sysdate, 12) from dual; -- add 1 year
Select sysdate, add_months (sysdate, 1) from dual; -- add January
Select sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 week
Select sysdate, to_char (sysdate + 1, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 day
Select sysdate, to_char (sysdate + 1/24, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 hour
Select sysdate, to_char (sysdate + 1/24/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 minute
Select sysdate, to_char (sysdate + 1/24/60/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 second

Subtraction

Select sysdate, add_months (sysdate,-12) from dual; -- minus 1 year
Select sysdate, add_months (sysdate,-1) from dual; -- minus January
Select sysdate, to_char (sysdate-7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- minus 1 week
Select sysdate, to_char (sysdate-1, 'yyyy-mm-dd HH24: MI: ss') from dual; -- minus 1 day
Select sysdate, to_char (sysdate-1/24, 'yyyy-mm-dd HH24: MI: ss') from dual; -- minus 1 hour
Select sysdate, to_char (sysdate-1/24/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- minus 1 minute
Select sysdate, to_char (sysdate-1/24/60/60, 'yyyy-mm-dd HH24: MI: ss') from dual; -- minus 1 second

To_char (sid. ship_date + cst. total_times/24, 'dd/mm/yyyy HH24: MI ') total_times

Sid. ship_date and cst. total_times are added to total_times in hours.

To_char (round (to_number (sid. sign_in_date-(sid. ship_date + cst. total_times/24) * 24) t_hour

Oracle date Subtraction
Sid. sign_in_date minus (sid. ship_date + cst. total_times/24), convert to_number () to hour, convert to round (), and convert to to_char ()

We have introduced so much about addition and subtraction in the previous article, and hope it will be helpful to you.