有关SQL日期时间之间的条文的问题

尝试:codeprelang="SQL"spanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spanmyTablespanclass="code-keyword"WHERE/spanmyDatespanclass="code-keyword"BETWEEN/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-05'/spanspanclass="code-keyword"AND/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-25'/span/pre/code注意之间的包容性，所以两日将在结果中
thatraja

imgsrc=像下面其中一份样本codeprelang="SQL"spanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spanTableNamespanclass="code-keyword"WHERE/spanDateColumspanclass="code-keyword"BETWEEN/spanspanclass="code-keyword"CONVERT/span(spanclass="code-keyword"VARCHAR/span(spanclass="code-digit"10/span),GETDATE(),spanclass="code-digit"101/span)spanclass="code-keyword"AND/spanspanclass="code-keyword"CONVERT/span(spanclass="code-keyword"VARCHAR/span(spanclass="code-digit"10/span),GETDATE(),spanclass="code-digit"101/span)/pre/code
奥姆・普拉卡什・潘特

考虑下面的例子:codeprelang="SQL"spanclass="code-keyword"Create/spanspanclass="code-keyword"Table/spanEvents(IDspanclass="code-keyword"int/span,EDatespanclass="code-keyword"datetime/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/spaneventsspanclass="code-keyword"values/span(spanclass="code-digit"1/span,spanclass="code-string"'/spanspanclass="code-string"2011-08-0505:22:44:00'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/spaneventsspanclass="code-keyword"values/span(spanclass="code-digit"2/span,spanclass="code-string"'/spanspanclass="code-string"2011-08-0507:22:44:00'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/spaneventsspanclass="code-keyword"values/span(spanclass="code-digit"3/span,spanclass="code-string"'/spanspanclass="code-string"2011-08-2505:33:12:18'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/spaneventsspanclass="code-keyword"values/span(spanclass="code-digit"4/span,spanclass="code-string"'/spanspanclass="code-string"2011-08-2503:33:12:18'/span) Thiswillgiveyouspanclass="code-keyword"all/spanrecords spanclass="code-keyword"select/span*spanclass="code-keyword"from/spaneventsspanclass="code-keyword"where/spaneDatespanclass="code-keyword"between/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-0505:22:44:00'/spanspanclass="code-keyword"and/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-2505:33:12:18'/span spanclass="code-digit"1/span 2011-08-0505:22:44.spanclass="code-digit"000/spanspanclass="code-digit"2/span 2011-08-0507:22:44.spanclass="code-digit"000/spanspanclass="code-digit"3/span 2011-08-2505:33:12.spanclass="code-digit"017/spanspanclass="code-digit"4/span 2011-08-2503:33:12.spanclass="code-digit"017/span Thiswillgiveyouselectedrecords(excludingthethirdrecord) spanclass="code-keyword"select/span*spanclass="code-keyword"from/spaneventsspanclass="code-keyword"where/spaneDatespanclass="code-keyword"between/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-0505:22:44:00'/spanspanclass="code-keyword"and/spanspanclass="code-string"'/spanspanclass="code-string"2011-08-2503:33:12:18'/spanspanclass="code-digit"1/span 2011-08-0505:22:44.spanclass="code-digit"000/spanspanclass="code-digit"2/span 2011-08-0507:22:44.spanclass="code-digit"000/spanspanclass="code-digit"4/span 2011-08-2503:33:12.spanclass="code-digit"017/span /pre/code希望这有助于..