欢迎投稿

今日深度:

Oracle 查询三个月之内,Oracle三个月

Oracle 查询三个月之内,Oracle三个月


自带函数:add_months(sysdate,-3)


select add_months(sysdate,-3) from dual




Time Start: 2015/1/12 15:00:38

SYSDATE    ADD_MONTHS(SYSDATE,-3)
---------- ----------------------
2015-01-12 2014-10-12            
1 row selected.
Time End: 2015/1/12 15:00:38
Elapsed Time for Script Execution: 73 msecs

www.htsjk.Com true http://www.htsjk.com/shujukunews/5878.html NewsArticle Oracle 查询三个月之内,Oracle三个月 自带函数:add_months(sysdate,-3) select add_months(sysdate,-3) from dual Time Start: 2015/1/12 15:00:38 SYSDATE ADD_MONTHS(SYSDATE,-3) ---------- ---------------------- 2015-01-12 2014-10-...
评论暂时关闭