13,201,452 members (73,971 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 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
Rate this:

## Solution 1

Use HH to have difference in Hours.

DATEDIFF(HH,start_date, end_date) as Hour

Top Experts
Last 24hrsThis month
 OriginalGriff 300 Richard MacCutchan 125 GKP1992 75 Karthik Bangalore 70 Dave Kreskowiak 55
 OriginalGriff 8,060 ppolymorphe 2,014 Karthik Bangalore 1,724 CPallini 1,208 Jochen Arndt 1,075