Display time elapsed few seconds ago, minute ago, hours ago, days ago and year ago in SQL Server

Hi micah,

Execute the below sql in your database you are using for your project and check.

DROP FUNCTION [dbo].[GetTimeFromCurrentDate]
GO
DROP PROC [dbo].[GetUserUserPostFriends2]
GO

CREATE FUNCTION [dbo].[GetTimeFromCurrentDate](@TempDate DATETIME)
RETURNS NVARCHAR(200)
AS
BEGIN
    DECLARE @TimeFormat NVARCHAR(200)
    DECLARE @Minutes INT
    DECLARE @Hours INT
    DECLARE @Days INT
    DECLARE @Months INT
    DECLARE @Years INT
       
    SET @Years = DATEDIFF(yy,@TempDate,GETDATE())
    SET @Months = DATEDIFF(mm,@TempDate,GETDATE())
    SET @Days = DATEDIFF(dd,@TempDate,GETDATE())
    SET @Hours = DATEDIFF(hh,@TempDate,GETDATE())
    SET @Minutes = DATEDIFF(mi,@TempDate,GETDATE())
    SET @Minutes = @Minutes - (@Hours * 60)
        
    IF @Years = 0 AND @Months = 0 AND @Days = 0 AND @Hours = 0 AND @Minutes > 0
        BEGIN
            SET @TimeFormat = CONVERT(VARCHAR,@Minutes) + ' minute/s ago'
        END
    ELSE IF @Years = 0 AND @Months = 0 AND @Days = 0 AND @Hours > 0 AND @Minutes > 0
        BEGIN
            SET @TimeFormat = CONVERT(VARCHAR,@Hours) + ' hour/s ago'
        END
    ELSE IF @Years = 0 AND @Months = 0 AND @Days > 0 AND @Hours > 0 AND @Minutes > 0
        BEGIN
            SET @TimeFormat = CONVERT(VARCHAR,@Days) + ' day/s ago'
        END
    ELSE IF @Years = 0 AND @Months > 0 AND @Days > 0 AND @Hours > 0 AND @Minutes > 0
        BEGIN
            SET @TimeFormat = CONVERT(VARCHAR,@Months) + ' month/s ago'
        END
    ELSE IF @Years > 0 AND @Months > 0 AND @Days > 0 AND @Hours > 0 AND @Minutes > 0
        BEGIN
            SET @TimeFormat = CONVERT(VARCHAR,@Years) + ' year/s ago'
        END
    RETURN @TimeFormat;
END
GO

CREATE PROC [dbo].[GetUserUserPostFriends2]
    @Id INT = NULL
AS
BEGIN
	SELECT t.Id as Id,t.Name,t.ImageName,w.COUNTSTATUS,w.FromId,v.FollowingId,v.FollowerId,s.ImageName1,
			s.MyId,s.Message,s.SendDate,s.MyId as ScrapId, dbo.GetTimeFromCurrentDate(s.SendDate) as timeFromCurrentDate
	FROM [User] as t, USERPOST1 as s, Followers as v, IncrementDecrement as w  
	WHERE s.MyId=t.ID AND v.FollowingId = @Id ORDER BY Id DESC
END

Ok i have seen the problem. this is the correction below

<div class="col=lg-6">                                
   <img src="../Images/logo5.png" />  &nbsp;  &nbsp;   <asp:Label ID="SendDate" runat="server" Text='<%# Eval("timeFromCurrentDate","{0:ddd,dd MMMM yyyy }") %>'   Font-Size="Smaller" Font-Bold="True"  />
</div>          

thanks