从一个月的MySQL获取两个日期和最后一天之间的星期天日期 [英] Get sunday date between two date and last day from one month mysql

问题描述

我想获取两个日期之间的所有星期日日期，并获取两个日期之间的最后一天，我该如何在mysql中做到这一点? 示例:

I want to get all sunday date between two dates and get last day between two date, how can i do that in mysql? Example :

start date | end date
2017-03-01 | 2017-03-31

那么结果是:

2017-03-05
2017-03-12
2017-03-19
2017-03-26
2017-03-31

开始日期和结束日期可能会更改，请告诉我. 谢谢

Start date and end date possible to change, please advise me. Thank you

推荐答案

SELECT calender FROM calender WHERE calender.calender >='2017-03-01' AND calender.calender <='2017-03-31'  AND DAYOFWEEK(calender) = 1 OR calender = '2017-03-31' Group By calender

这是@Tim答案 谢谢蒂姆

This is @Tim Answer Thanks Tim

这篇关于从一个月的MySQL获取两个日期和最后一天之间的星期天日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！