OuterApply
New member
- Local time
- Today, 10:41
- Joined
- Mar 10, 2022
- Messages
- 15
Datediff(hour,startdatetime,stopdatetime) returns INT.
Datediff(hour,startdatetime,stopdatetime)/24 still returns INT.
I want a decimal or two on there, so that I can calculate partial days (it all adds up when aggregating).
What's the proper solution and understanding of same?
Datediff(hour,startdatetime,stopdatetime)/24 still returns INT.
I want a decimal or two on there, so that I can calculate partial days (it all adds up when aggregating).
What's the proper solution and understanding of same?