如何选择两个日期之间的所有时间？

试试这个。使用

Recursive CTE

DECLARE @minDateTime AS DATETIME;DECLARE @maxDateTime AS DATETIME;SET @minDateTime = '2014-01-13 02:00:00';SET @maxDateTime = '2014-12-31 14:00:00';;WITH Dates_CTE     AS (SELECt @minDateTime AS Dates         UNIOn ALL         SELECT Dateadd(hh, 1, Dates)         FROM   Dates_CTE         WHERe  Dates < @maxDateTime)SELECt *FROM   Dates_CTEOPTION (MAXRECURSION 0)

在上面的查询

Dates_CTE

Common expression Table

CTE

UNIOnALL

Minimum date

UNIOn ALL

recursive

@maxDateTime