13,193,600 members (57,667 online)
Rate this:
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

Rate this:

## Solution 1

Use HH to have difference in Hours.

```DATEDIFF(HH,start_date, end_date) as Hour
```
Rate this:

## 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

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

Top Experts
Last 24hrsThis month
 OriginalGriff 385 Jochen Arndt 255 Karthik Bangalore 200 Kornfeld Eliyahu Peter 160 CPallini 130
 OriginalGriff 6,550 ppolymorphe 1,639 Karthik Bangalore 1,354 Jochen Arndt 1,020 Richard Deeming 824

Advertise | Privacy |
Web03 | 2.8.171018.2 | Last Updated 19 Jan 2013