mysql 获取当月每一天_[MySQL]获取当月每一天

最新推荐文章于 2023-06-05 11:33:05 发布

周小囧

最新推荐文章于 2023-06-05 11:33:05 发布

阅读量195

点赞数

文章标签： mysql 获取当月每一天

本文链接：https://blog.csdn.net/weixin_31614235/article/details/113295736

版权

博客主要介绍了如何在MySQL中统计指定月份内的每一天数据量，以及如何扩展到获取时间区间内的每分钟数据。同时也提供了Oracle数据库的相关查询方法。

摘要由CSDN通过智能技术生成

 
    select date_add(curdate(), interval(cast(help_topic_id as signed integer) - 1) day) day 
   

from mysql.help_topic

 
    where help_topic_id < day(last_day(curdate())) 
   

order by help_topic_id

 
    set @stime = str_to_date('2018-11-07 08:00', '%Y-%m-%d %H:%i'); 
   

 
    set @etime = str_to_date('2018-11-07 08:10', '%Y-%m-%d %H:%i'); 
   

 
    select date_add(@stime, interval (cast(help_topic_id as signed integer) - 0) minute) minute 
   

from mysql.help_topic

 
    where help_topic_id <= timestampdiff(minute, @stime, @etime) 
   

order by help_topic_id

 
    select trunc(sysdate, 'MM') + rownum - 1 day 
   

from dual

 
    connect by rownum <= to_number(to_char(last_day(sysdate), 'dd')) 
   

原文地址：https://blog.csdn.net/reeye_/article/details/83655477

关注