Hi all

I am trying to get the day diff in days, hours, minutes between 2 dates

I was able to do so in Oracle but haven't succeeded in SQL server


Here is the code:

select

DateDiff(Day, PROCESS.date_created, PROCESS.date_modified)as days,

datediff(hour,PROCESS.date_created, PROCESS.date_modified) as hours,

datediff(minute,PROCESS.date_created, PROCESS.date_modified) as minues

from

PROCESS

How ever they are ther are not calculated all together



How can I combine them into one full time diff (days, hours, minutes) ?