sysdate minus 1 day

For more information about the use of ORACLE time functions (SYSDATE), oraclesysdate Addition Select sysdate, add_months (sysdate, 12) from dual; -- add 1 year select sysdate, add_months (sysdate, 1) from dual; -- add January select sysdate,

Oracle sysdate addition/subtraction code instance, oraclesysdateAddition 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,

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,

addition Select Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

Addition Select sysdate, add_months (sysdate, 12) from dual; -- add 1 yearSelect sysdate, add_months (sysdate, 1) from dual; -- add JanuarySelect sysdate, to_char (sysdate + 7, 'yyyy-mm-dd HH24: MI: ss') from dual; -- add 1 weekSelect sysdate,

Addition Select Sysdate,add_months (sysdate,12) from dual; --plus 1 select Sysdate,add_months (sysdate,1) from dual;--plus January select Sysdate,to_char (sysdate+7, ' yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeks select Sysdate,to_char

addition Select Sysdate,add_months (sysdate,12) from dual; --plus 1 years Select Sysdate,add_months (sysdate,1) from dual; --Add January Select Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeks Select Sysdate,to_char (

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

AdditionSelect Sysdate,add_months (sysdate,12) from dual; --plus 1 yearsSelect Sysdate,add_months (sysdate,1) from dual; --Add JanuarySelect Sysdate,to_char (sysdate+7, ' Yyyy-mm-dd HH24:MI:SS ') from dual; --plus 1 weeksSelect Sysdate,to_char

Blog. csdn. netjjgjlfarticledetails6640346 small Oracle date week first day of this quarter SELECTto_char (TRUNC (SYSDATE, Q), YYYY-MM-DD) FROMdual; -- previous Http://blog.csdn.net/jjgjlf/article/details/6640346 dig Oracle date ---------------------