13,513,726 members
See more:
i have to convert datediff of start_time and end_time into hours.I have convert this diff into minute.this will work, but i have to convert it into hours.how to do this ?
below code that i have used to convert it into minute.
`SqlCommand cmd0 = new SqlCommand("select *,Datediff(mi,start_date,end_date) as Duration,Datediff(h,start_date,end_date) from project_log  where (end_date between '" + txt_datefrom.Text + "' and '" + txt_dateto.Text + "' or start_date between '" + txt_datefrom.Text + "' and '" + txt_dateto.Text + "') and " + ddlsearchby.SelectedValue + " LIKE '" + txt_searchText.Text + "%'", cnn);`
Posted 19-Jan-13 0:57am

Solution 1

Use HH to have difference in Hours.

```DATEDIFF(HH,start_date, end_date) as Hour
```

Solution 2

HI,

you can use like the following:

```DateTime a = new DateTime(2008, 01, 02, 06, 30, 00);
DateTime b = new DateTime(2008, 01, 03, 06, 30, 00);
TimeSpan duration = b - a;
double hours = (b-a).TotalHours;```

OR

`int days = (int)Math.Ceiling(diff.TotalDays);`

Thanks

Top Experts
Last 24hrsThis month
 Jochen Arndt 345 OriginalGriff 345 Maciej Los 315 Wendelius 205 ppolymorphe 190
 OriginalGriff 5,511 Jochen Arndt 3,318 Maciej Los 2,734 ppolymorphe 2,552 Wendelius 2,408