//The code below will get you a date and time 72 ago. DECLARE @HoursAgo DATETIME = DATEADD(HOUR, -72, GETDATE()); SELECT @HoursAgo AS DaysOrHoursAgo;