Use DATEDIFF(minute, shiftStart.timeEntered, shiftEnd.timeEntered) * 1.0 / 60 instead, to give you the hour as a decimal.
LittleBobbyTables
2010-10-09 02:14:13
+3
A:
Great ... I get a value that looks like this:
Beginner_Pal
2010-10-09 03:30:57
4.514406 ..... I need a simple quick way to truncate the decimal without rounding to one decimal place so the output be as 4.5 ... Any idea?
Beginner_Pal
2010-10-09 03:32:08
Got it...........
Beginner_Pal
2010-10-09 19:06:58
Excellent trick here.
prabhats.net
2010-10-19 18:57:59
+1
A:
Time card stuff is very business rule intensive. I would consider your architecture before putting all the rules in sp's.
Decker97
2010-10-09 04:00:15
A:
This will return the Hours & Minutes: CAST(DATEDIFF(MINUTE, StartTime, EndTime) AS DECIMAL)/60
Yaqub Ahmad
2010-10-09 06:54:35