13,352,408 members (54,372 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 1: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

Top Experts
Last 24hrsThis month
 ProgramFOX 300 OriginalGriff 170 Richard MacCutchan 50 Jochen Arndt 45 CHill60 40
 OriginalGriff 3,966 ProgramFOX 1,213 Maciej Los 1,210 Jochen Arndt 1,201 Karthik Bangalore 1,151