DAY COUNT IN SQL SERVER 2005

CREATE PROC dt_count

(

@D1 DATETIME,

@D2 DATETIME

)

AS

BEGIN

SELECT DATEPART (year, @d2-@d1)-1900 as YEARS,

DATEPART (month, @d2-@d1)-1 as MONTHS,

DATEPART (day, @d2-@d1)-1 as DAYS,

DATEPART (hour, @d2-@d1) as HOURS, DATEPART (minute, @d2-@d1) as MINUTES,

DATEPART (second, @d2-@d1) as SECONDS,

DATEPART (millisecond, @d2-@d1) as MILLISECONDS

END

-- EXEC dt_count '08/20/1987','01/01/2013'

-- EXEC dt_count '1985-11-29 21:45:00', '1987-08-20 07:45:00'

-- SELECT GETUTCDATE()
 

-- SELECT GETDATE()

-- SELECT CONVERT(VARCHAR, GETDATE(), 121)