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

Steve

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.