月日比较

oyprunner

于 2010-02-23 17:58:18 发布

阅读量167

点赞数

分类专栏： sql 文章标签： C C++ C# SQL

sql 专栏收录该内容

6 篇文章

订阅专栏

select substr(('0' || Extract(MONTH from ins.t_end_date)), 2) ||
       substr(('0' || Extract(DAY from ins.t_end_date)), -2),
       substr('0' ||
              Extract(MONTH from
                      to_date(to_char(add_months(sysdate, 3), 'yyyy-mm-dd'),
                              'yyyy-mm-dd')),
              2) ||
       substr('0' || Extract(DAY FROM to_date(to_char(add_months(sysdate, 3),
                                             'yyyy-mm-dd'),
                                     'yyyy-mm-dd')),
              2)
  from tb_ins_info ins
 where ins.c_del = '0'
   and ins.c_stat = '99'
   and ins.c_cst_id = '23'
   and substr(('0' || Extract(MONTH from ins.t_end_date)), 2) ||
       substr(('0' || Extract(DAY from ins.t_end_date)), -2) <=
       substr('0' ||
              Extract(MONTH from
                      to_date(to_char(add_months(sysdate, 3), 'yyyy-mm-dd'),
                              'yyyy-mm-dd')),
              2) ||
       substr('0' || Extract(DAY FROM to_date(to_char(add_months(sysdate, 3),
                                             'yyyy-mm-dd'),
                                     'yyyy-mm-dd')),
              2)
   and ins.t_end_date > sysdate