I'm doing like this..!!!
DECLARE @minutes AS INT
SET @minutes = 1.80*100
SELECT @minutes / 60 + (@minutes % 60) / 100.0 AS Hours
it gives me 3.000 but the result should be 2.20 hrs
how can i acheive that..?
pls help me out
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
VulpesPosted Feb 22, 2014, 1:26 PM
Shweta LodhaPosted Feb 22, 2014, 1:15 PM
Did you checked this, it is from day to hours but may provide you pointer:
http://stackoverflow.com/questions/1770594/how-to-calculate-difference-in-hours-decimal-between-two-dates-in-sql-server