04 2021 档案

Oracle对当前时间的处理

摘要：select SYSDATE, to_date(to_char(add_months(TRUNC(SYSDATE, 'Q'), -0), 'yyyy-mm-dd')||' 00:00:00','yyyy-mm-dd hh24:mi:ss')as 当前季度开始, to_date(to_char(add 阅读全文

posted @ 2021-04-20 10:50 xiaoYu& 阅读(296) 评论(0) 推荐(0) 编辑

Oracle合并不同条件下统计出的总数

摘要：select a.sum1, b.sum2 from(select count(*) as sum1 from docinfo) a,(select count(*) as sum2 from docinfo where to_char(createtime,'yyyy-mm-dd') < '202 阅读全文

posted @ 2021-04-19 16:55 xiaoYu& 阅读(260) 评论(0) 推荐(0) 编辑