Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: difference between times in minutes

Bottom of Page

1 to 2 of 2

  1.  
    • CommentAuthorjohn
    • CommentTimeNov 12th 2006
     
    Hi,

    I want to calculate the difference between 2 times in minutes in that my goal is to assertain if a entry was made with in 15 minutes ago. So

    CURTIME() and a field defined in database called timeAdded which is of type
    TIME 00:00:00

    I thought i could use :

    DATEDIFF(isres.timeAdded , CURTIME()) AS NumberOfMinutes

    but i get no return value here.

    Any help would be appreciated.

    cheers
    • CommentAuthorhardy
    • CommentTimeNov 12th 2006
     
    You are missing the first parameter for datediff, which is the datepart to return a value in

    datediff(datepart, startdate, enddate)

    use mi or n for datepart in minutes.

1 to 2 of 2

  1.