mysql:检查日期范围 [英] mysql : check date range

问题描述

我们具有类似

id | startDay | startMonth | startYear | endDay | endMonth | endYear    
1  | 22       | 12         | 2012      | 25     | 1        | 2013  

现在，我们还有另一个日期范围，例如startDate，startMonth，startYear，即 25 | 12 | 2012 和endDay，endMonth，endYear，即 10 | 1 | 2013 .

我希望查询从表中获取提供的日期范围在表中的记录.在这种情况下，意味着要先记录.
如何为此编写查询?

Now we have another date range like startDate,startMonth, startYear i.e. 25|12|2012 and endDay,endMonth,endYear i.e 10|1|2013.

I want the query to get the records from table where provided date range is present in table. Means record first in this case.
How to write query for this?

推荐答案

首先，使用@ MarcB 的建议.但是，如果您没有时间更改表，也可以使用以下查询.

First, take @MarcB's advice. But if you don't have time to alter your table, alternatively, you can also use the following query.

SELECT *
FROM tableName
WHERE ('2012-12-25' BETWEEN DATE(CONCAT_WS('-', startYear, startMonth, startDay)) AND
                  DATE(CONCAT_WS('-', endYear, endMonth, endDay))) AND
      ('2013-01-10' BETWEEN DATE(CONCAT_WS('-', startYear, startMonth, startDay)) AND
                  DATE(CONCAT_WS('-', endYear, endMonth, endDay))) 

• SQLFiddle演示链接
• SQLFiddle Demo Link

这篇关于mysql:检查日期范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！