--Description: Returns all dates between two dates <Description,,>
-- =============================================
CREATE FUNCTION [dbo]. [Getbetweendate]
(
@StartTime DATETIME--Start date
, @EndTime DATETIME--End date
)
RETURNS @TABLE TABLE (betweendate DATETIME)--returned result set
As
BEGIN
DECLARE @day INT
SELECT @day =datediff (Day, @StartTime, @EndTime)-Calculates the number of days between two dates
/* Make a loop processing (start) */
while (@day >0)
BEGIN
INSERT into @TABLE
(betweendate)
VALUES (DATEADD (Day, @day, @StartTime)--Add a record from the start time plus days, then do a minus 1 calculation, have accumulated
)
SET @[email protected]
END
/* Make a loop processing (end) */
INSERT into @TABLE (betweendate) VALUES (@StartTime)-Add the last record (that is, the start date)
RETURN
END
The results of the execution run are as follows:
SQL Returns a date _ function implementation between two dates