– Description: 计算两个时间的差别(例如:5天3小时24分)
CREATE FUNCTION [dbo].[F_DatetimeDiffToGB]
(
-- Add the parameters for the function here
@start DATETIME,
@end DATETIME,
@type VARCHAR(10)
)
RETURNS NVARCHAR(100)
AS
BEGIN
-- Declare the return variable here
DECLARE @Years INT,
@Months INT,
@Days INT,
@Hours INT,
@Minutes INT,
@Seconds INT,
@ReturnValue NVARCHAR(100)
DECLARE @Days1 INT,
@Hours1 INT,
@Minutes1 INT,
@Second1 INT
-- Add the T-SQL statements to compute the return value here
SELECT @Years=DATEDIFF(YEAR, @start, @end),
@Months=DATEDIFF(MONTH, @start, @end),
@Days=DATEDIFF(DAY, @start, @end),
@Hours=DATEDIFF(