I need a Date Difference 1

[LeonelSanchezJr]

I've tried the datediff() function, but that gives me a choice of hours or minutes.

I need to find out how many days, hours and minutes have elapsed between a start datetime field and an end datetime field.

How can I do this.

 

[tlbroadbent]

Try this SQL code.

Select
datediff(day,StartDate,EndDate)/24 As NoDays,
Datediff(hour,StartDate,EndDate) % 24 As NoHrs,
Datediff(minute,StartDate,EndDate) % 60 As NoMins
From tbl

Note: % is the modulo operator in T-SQL. Terry Broadbent


"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin