Where The Streets Have No Name

Oracle Date How to Add Day , Hour, Minute, Second to a Date Value in Oracle 본문

Developement/DataBase

Oracle Date How to Add Day , Hour, Minute, Second to a Date Value in Oracle

highheat 2013. 6. 18. 17:59

Oracle Date How to Add Day , Hour, Minute, Second to a Date Value in Oracle


 Oracle add Days

Oracle add Hour
Oracle add Minute
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 hh24:mi:ss') "Todays-date" , 

to_char(sysdate +1/(24*60*60),'dd-mm-yyyy hh24:mi:ss') One_second from 

dual ;


Todays-date         ONE_SECOND
------------------- -------------------
05-01-2012 12:56:27 05-01-2012 12:56:28


출처 : http://anuj-singh.blogspot.kr/2012/01/date-how-to-add-day-hour-minute-second.html

저작자표시 (새창열림)
'Developement/DataBase' Related Articles more