如何在两种日期之间搜索日期 [英] how to search date between two variety of dates

问题描述

我有一张带有from_date和To_date的表格



i想要找到from_date列到To_date列之间的日期





例如。



To_Date From_Date

2014-03-01 2014-02 -26

2014-02-15 2014-02-15



如果我在27/2/2014进行搜索，我期待



To_Date From_Date

2014-03-01 2014-02-26



请帮帮我

解决方案

尝试：

  SELECT  *  FROM  MyTable  WHERE  '  2013-02-27'  BETWEEN  From_Date 和 To_Date 

i have a table with from_date and To_date

i want to find a date between a from_date column to To_date column


for eg.

To_Date From_Date
2014-03-01 2014-02-26
2014-02-15 2014-02-15

if i give a search with 27/2/2014, i expect

To_Date From_Date
2014-03-01 2014-02-26

Please help me

解决方案

Try:

SELECT * FROM MyTable WHERE '2013-02-27' BETWEEN From_Date and To_Date

这篇关于如何在两种日期之间搜索日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！