Viewing 2 posts - 1 through 2 (of 2 total)
Thank you both, Dhasian and Sartori!
Both suggestions worked fine!
October 29, 2010 at 6:53 am
#1244130
Sorry, it return only whole number (I think it's Integer).
The Datepart function for the minutes should return 0,5 but return 0.
SELECT skjema_nr, skjema_arb_lengde, DATEPART(mi, skjema_arb_lengde) / 60 AS Expr1
FROM ...
October 29, 2010 at 6:25 am
#1244097