Hello, I supposed this is an easy question to be solved:
I correctly execute this statement:
DATEDIFF("h", [StarTime], [EndTime]) AS TotalHrs,
but ASPrunner displays the date difference(in my case, hour difference) rounding the hours:
for example:
a startTime 12.00 pm. endtime 2:30 pm the TotalHrs column looks like "3" hrs - instead of 2.3 hrs.
what shall I do to correct it?
Thanks