13,353,106 members (55,822 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

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 190 ProgramFOX 90 Richard MacCutchan 50 CPallini 50 David_Wimbley 45
 OriginalGriff 4,151 ProgramFOX 1,268 Maciej Los 1,210 Jochen Arndt 1,201 Karthik Bangalore 1,151

Advertise | Privacy |
Web01 | 2.8.180111.1 | Last Updated 19 Jan 2013