Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Datediff help
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Datediff help
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01351543
Message ID:
01351543
Views:
60
I need to return two values based off an elasped time. The first value (field) needs to represent the hours, the second the minutes but not total minutes. So if the elasped time was 62 minutes, I need the first value to be 1 and the second value to be 2. Right now I was doing it on the client side, but I need to have it in the stored procedure. I was hoping someone knew a way to do that cleanly.
isnull(datediff(mi,meetings.ProcStart,meetings.ProcEnd),0) as TotalDurationMins,
isnull(datediff(mi,meetings.ProcStart,meetings.ProcEnd),0) as HolderMins,
Thanks

Kirk
Next
Reply
Map
View

Click here to load this message in the networking platform