ORACLE 计算时间区间

最新推荐文章于 2024-06-21 08:00:00 发布

weixin_30399797

最新推荐文章于 2024-06-21 08:00:00 发布

阅读量270

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/qq1988627/p/6638216.html

版权

buffer.append(" with date_info as(");
buffer.append(" select to_date('"+param.get("BEGIN_TIME")+"','yyyy-mm-dd') as start_date,");
buffer.append(" to_date('"+param.get("END_TIME")+"','yyyy-mm-dd')-to_date('"+param.get("BEGIN_TIME")+"','yyyy-mm-dd')+1 as dt");
buffer.append(" from dual),");
buffer.append(" date_group as(");
buffer.append(" select start_date+(level-1) as start_date,");
buffer.append(" start_date+level as end_date");
buffer.append(" from date_info connect by level<=date_info.dt");
buffer.append(" ),");

转载于:https://www.cnblogs.com/qq1988627/p/6638216.html