oracle 时间比较sql

最新推荐文章于 2016-06-20 17:11:34 发布

znie

最新推荐文章于 2016-06-20 17:11:34 发布

阅读量730

点赞数

分类专栏：数据库文章标签： oracle sql 时间

本文链接：https://blog.csdn.net/u013320750/article/details/44039277

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

--获取到上个月今天
SELECT add_months(sysdate,-1) as from dual;
SELECT trunc(add_months(sysdate,-1)) as from dual;
--获取到去年今天
SELECT add_months(sysdate,-12) as from dual;
SELECT trunc(add_months(sysdate,-12)) as from dual;
--获取到半年前
SELECT add_months(sysdate,-6) as from dual;
SELECT trunc(add_months(sysdate,-6)) as from dual;
--获取昨天
select sysdate-1  from dual;
select trunc(sysdate-1)  from dual;
--获取到一周
select sysdate-7  from dual;
select trunc(sysdate-7)  from dual;

--比较
select sysdate, to_date('2015-03-02 22:12:10','yyyy-mm-dd hh24:mi:ss') from dual where sysdate<to_date('2015-03-02 22:12:10','yyyy-mm-dd hh24:mi:ss')
--一天之内
select sysdate from dual where to_date('2015-03-01 22:12:10','yyyy-mm-dd hh24:mi:ss')>=(sysdate-1)
--一周之内
select sysdate from dual where to_date('2015-03-01 22:12:10','yyyy-mm-dd hh24:mi:ss')>=(sysdate-7)
--一个月以内
select sysdate from dual where to_date('2015-02-21 22:12:10','yyyy-mm-dd hh24:mi:ss')>=add_months(sysdate,-1)
--半年
select sysdate from dual where to_date('2015-02-21 22:12:10','yyyy-mm-dd hh24:mi:ss')>=add_months(sysdate,-6)
--一年
select sysdate from dual where to_date('2015-02-21 22:12:10','yyyy-mm-dd hh24:mi:ss')>=add_months(sysdate,-12)
--一年以上
select sysdate from dual where to_date('2015-02-21 22:12:10','yyyy-mm-dd hh24:mi:ss')<add_months(sysdate,-12)