Humanize Date SQL Function

Example.sql

SELECT dbo.humanizeDate(getdate()-1.56)
SELECT dbo.humanizeDate(getdate()-1)
SELECT dbo.humanizeDate(getdate()-.56)
SELECT dbo.humanizeDate(getdate()+22.56)

HumanizeDate.sql

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION HumanizeDate
(
	@timestamp AS datetime
)
RETURNS varchar(max)
AS
BEGIN
	DECLARE @result as Varchar(max)
	DECLARE @now AS datetime= getdate()
	

	SELECT @result=
    CONVERT(VARCHAR(40), abs(DATEDIFF(minute, @timestamp, @now)/(24*60)))+ ' days, '
   + CONVERT(VARCHAR(40), abs(DATEDIFF(minute, @timestamp, @now)%(24*60)/60)) + ' hours, and '
   + CONVERT(VARCHAR(40), abs(DATEDIFF(minute, @timestamp, @now)%60))+ ' minutes '
   + CASE WHEN @timestamp<=@now THEN 'ago' ELSE 'from now' end

   set @result = Replace(@result,'1 days','1 day')
   set @result = Replace(@result,'1 hours','1 hour')
   set @result = Replace(@result,'1 minutes','1 minute')
   set @result = Replace(@result,'0 days, ','')
   set @result = Replace(@result,', and 0 minutes','')
   set @result = Replace(@result,', 0 hours','')

	RETURN isnull(@result,'never')

END
GO

HumanizeDuration.sql

 USE dba
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION HumanizeDurationInMinutes
(
	@minutes AS int
)
RETURNS varchar (max)
AS
BEGIN
	
	DECLARE @ResultVar nvarchar(max)

	SELECT @ResultVar = CAST(CAST((SUM(@minutes)) AS INT) / 60 AS VARCHAR)
			+' hr '+
			RIGHT('0'+CAST(CAST((SUM(@minutes)) AS INT) % 60 AS VARCHAR(2)), 2)+' min'

	-- Return the result of the function
	RETURN @ResultVar

END
GO