Oracle Date How to Add Day , Hour, Minute, Second to a Date Value:-
1)Oracle add Days 2)Oracle add Hour 3)Oracle add Minute 4)Oracle add second -- # Add a day select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') "Todays-date" , to_char(sysdate +1 ,'dd-mm-yyyy hh24:mi:ss') One_day from dual ; Todays-date ONE_DAY ------------------- ------------------- 05-01-2012 12:55:52 06-01-2012 12:55:52 -- # Add an hour select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') "Todays-date" , to_char(sysdate +1/24 ,'dd-mm-yyyy hh24:mi:ss') One_hour from dual ; Todays-date ONE_HOUR ------------------- ------------------- 05-01-2012 12:56:06 05-01-2012 13:56:06 -- # Add an Minute select to_char(sysdate,'dd-mm-yyyy hh24:mi:ss') "Todays-date" , to_char(sysdate +1/(24*60) ,'dd-mm-yyyy hh24:mi:ss') One_minute from dual ; Todays-date ONE_MINUTE ------------------- ------------------- 05-01-2012 12:56:18 05-01-2012 12:57:18 -- # Add Second select to_char(sysdate,'dd-mm-yyyy