日期之间的SQL [英] SQL between dates

问题描述

我有两列（startdate& enddate）的表，我有两个提交日期（2012-02-29和2012-03-30）我试图获取startdate之间的数据（2012-02-29 ）和enddate（2012-03-30）

我尝试过

  i.startdate between'2012-02-29'and i.enddate'2012-03-30'
  

但没有工作，我已经google了几个小时没有明确的答案，任何帮助将不胜感激，谢谢提前。

解决方案

如果我理解正确：

1. 您的表格包含两个日期字段， StartDate 和 EndDate ，描述一个冗长的事件。


2. 你想要找到所有完全落入的事件在另外两个日期描述的期间，在这种情况下， 2012-02-29 和 2012-03-30 。 / li>
   

如果这是正确的，请使用：

  SEL ECT * FROM Events 
 WHERE StartDate> ='2012-02-29'AND EndDate< ='2012-03-30'; 
  

I have table with two columns (startdate & enddate) and I have two submission dates (2012-02-29 & 2012-03-30) I am trying to get the data between startdate (2012-02-29) and the enddate (2012-03-30)

I've tried

 i.startdate between '2012-02-29' and i.enddate '2012-03-30'

but that didnt work, I've been googling this for hours with no clear answer, any help would be appreciated, thanks in advance.

解决方案

If I understand correctly:

1. Your table contains two date fields, StartDate and EndDate, that describe a lengthy event.
2. You want to find all the events that fall completely within the period described by two other dates, in this case 2012-02-29 and 2012-03-30.

If this is correct then use this:

 SELECT * FROM Events 
   WHERE StartDate >= '2012-02-29' AND EndDate <= '2012-03-30';

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