Minute convert into Hour

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Dear,

I have two Column Start & End both are Datetime data type.

The Data is

Start End
12:30 15:00

The Total min is 150
i used below query

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)

Its giving correct result=150

But when i convert into hour

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60

then result is 2 but actual 150/60=2.5

How to do it.

Please help on this

Thanks
Basit.

Posted 19-Nov-15 0:17am

basitsar

Updated 19-Nov-15 0:20am

v2

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Accepted Answer · 2015-11-19T00:24:00

Solution 1

Did you try to divide by a non integer ?
Try to replace

SQL

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60

with

SQL

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0

as for many languages like C, C++, C#
a divide of integers result in an integer.

Posted 19-Nov-15 0:24am

Patrice T

Updated 19-Nov-15 0:25am

v2

Comments

basitsar 23-Nov-15 23:53pm

Thanks A lot.

PANKAJMAURYA · Accepted Answer · 2015-11-19T00:25:00

Solution 2

Use this code to get hour

SQL

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0

Posted 19-Nov-15 0:25am

PANKAJMAURYA

Comments

basitsar 23-Nov-15 23:53pm

Thanks A lot.

CPallini · Accepted Answer · 2015-11-19T00:25:00

Solution 3

Try

SQL

DATEDIFF(mi, dbo.Trn_Daily3.Dr_TimeStart, dbo.Trn_Daily3.Dr_TimeEnd)/60.0

See "/ (Divide) (Transact-SQL)"[^]

Posted 19-Nov-15 0:25am

CPallini

Comments

basitsar 23-Nov-15 23:53pm

Thanks A lot.

CPallini 24-Nov-15 2:32am

You are welcome.

Minute convert into Hour

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Minute convert into Hour

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us