首页 / MYSQL / mysql – 如何选择连续日期？

mysql – 如何选择连续日期？

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql – 如何选择连续日期？，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1641字，纯文字阅读大概需要3分钟。

内容图文

我有这样的查询：

SELECT  DISTINCT 
        S.date1 AS date1, 
        S.date2 AS date2,
        S.period AS period

FROM portfolio.scenario S 

WHERE S.date1 >= '2010-06-01' AND
      S.date2 <= '2010-07-01' AND
      S.period = 'WEEK'

输出是：

"2010-06-01 00:00:00","2010-06-08 00:00:00",WEEK
"2010-06-02 00:00:00","2010-06-09 00:00:00",WEEK
"2010-06-03 00:00:00","2010-06-10 00:00:00",WEEK
"2010-06-04 00:00:00","2010-06-11 00:00:00",WEEK
"2010-06-07 00:00:00","2010-06-14 00:00:00",WEEK
"2010-06-08 00:00:00","2010-06-15 00:00:00",WEEK
"2010-06-09 00:00:00","2010-06-16 00:00:00",WEEK
"2010-06-10 00:00:00","2010-06-17 00:00:00",WEEK
"2010-06-11 00:00:00","2010-06-18 00:00:00",WEEK
"2010-06-14 00:00:00","2010-06-21 00:00:00",WEEK
"2010-06-15 00:00:00","2010-06-22 00:00:00",WEEK
"2010-06-16 00:00:00","2010-06-23 00:00:00",WEEK
"2010-06-17 00:00:00","2010-06-24 00:00:00",WEEK
"2010-06-18 00:00:00","2010-06-25 00:00:00",WEEK
"2010-06-21 00:00:00","2010-06-28 00:00:00",WEEK
"2010-06-22 00:00:00","2010-06-29 00:00:00",WEEK
"2010-06-23 00:00:00","2010-06-30 00:00:00",WEEK
"2010-06-24 00:00:00","2010-07-01 00:00:00",WEEK

我需要的只是连续日期最早的最早日期1;

    "2010-06-01 00:00:00","2010-06-08 00:00:00",WEEK
    "2010-06-08 00:00:00","2010-06-15 00:00:00",WEEK
    "2010-06-15 00:00:00","2010-06-22 00:00:00",WEEK
    "2010-06-22 00:00:00","2010-06-29 00:00:00",WEEK

感谢任何有关该主题的帮助:)

解决方法:

使用功能性条款对性能来说并不是最佳的,但只要S.period保持一周,这就可以解决问题.

SELECT  DISTINCT 
        S.date1 AS date1, 
        S.date2 AS date2,
        S.period AS period

FROM portfolio.scenario S 

WHERE S.date1 >= '2010-06-01' AND
      S.date2 <= '2010-07-01' AND
      S.period = 'WEEK' AND
      DAYOFWEEK(S.date1) = DAYOFWEEK('2010-06-01');

内容总结

以上是互联网集市为您收集整理的mysql – 如何选择连续日期？全部内容，希望文章能够帮你解决mysql – 如何选择连续日期？所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/905335.html

来源：【匿名】