mysql:如何获取所选日期的下一个日期? [英] mysql: How to get next date of the selected day?

问题描述

我的问题是，我有一个名为每周休息设置"的表格，其中我选择每周休息一两天.如果我在星期六休息，那么我想找出第一个星期六的日期这是在所选月份的第一周.因此任何人都可以告诉我有关此问题的mysql查询.

My problem is, I have a form named 'weekly-off setting' in which I am selecting a one or two days as a weekly off.If I have weekly off on saturday then I want to find out the first saturdays date which is coming in the first week of the selected month.So can anyone tell me the mysql query for this problem.

谢谢.

推荐答案

您的陈述不清楚，但您要查找下一个星期六吗?

It's a little unclear from your statement, but you're trying to find the next Saturday?

select date_add(now(), interval 7-dayofweek(now()) day);

不幸的是，如果您在星期六，今天将返回 ，因此序列变为:

Which unfortunately will return today if you're on a Saturday, so the sequence becomes:

SET @OFFSET = 7-dayofweek(now());
SET @OFFSET = IF(@OFFSET = 0, 7, @OFFSET);
select date_add(now(), interval @OFFSET day);

可以组合为一个:

select date_add(now(), interval IF(7-dayofweek(now()) = 0, 7, 7-dayofweek(now())) day) as next;

这篇关于mysql:如何获取所选日期的下一个日期?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！