--addition SelectSysdate,add_months (Sysdate, A) fromDual--plus 1 years SelectSysdate,add_months (Sysdate,1) fromDual--Add January SelectSysdate,to_char (sysdate+7,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 weeks . SelectSysdate,to_char (sysdate+1,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 days SelectSysdate,to_char (sysdate+1/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 hours SelectSysdate,to_char (sysdate+1/ -/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 minutes . SelectSysdate,to_char (sysdate+1/ -/ -/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--plus 1 seconds .--Subtraction SelectSysdate,add_months (Sysdate,- A) fromDual--minus 1 years . SelectSysdate,add_months (Sysdate,-1) fromDual--minus January SelectSysdate,to_char (sysdate-7,'YYYY-MM-DD HH24:MI:SS') fromDual--minus 1 weeks . SelectSysdate,to_char (sysdate-1,'YYYY-MM-DD HH24:MI:SS') fromDual--minus 1 days SelectSysdate,to_char (sysdate-1/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--minus 1 hours . SelectSysdate,to_char (sysdate-1/ -/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--minus 1 minutes . SelectSysdate,to_char (sysdate-1/ -/ -/ -,'YYYY-MM-DD HH24:MI:SS') fromDual--minus 1 seconds .
--For exampleSelectPx_id,px_title,px_begin_time,px_end_time,px_address,px_count_limit,px_yy_begin_time, PX_YY_END_TIME,PX_NSR _limit,px_count,px_region,px_extra_count,px_extra_alert, Px_extra_flag,px_tx fromnsrxt_pxwhereTo_char (Px_create_time,'yyyy-mm')>To_char (Add_months (Sysdate,-3),'yyyy-mm')Order byPx_begin_timeASC, Px_countASC;
Date plus subtraction in Oracle