how to Convert integer value to time in c#

Question

I have i time in Integer = 59400  how can I convert it in C# to Timeformat = 22:03:00.0000000 My C# Code is below private void LoadOvertimetotal() { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); string str = SELECT total_sec = SUM(( DATEPART(hh Overtime_HHMM) * 3600 ) +( DATEPART(mi Overtime_HHMM) * 60 ) + DATEPART(ss Overtime_HHMM)) FROM Accounts_DailyAttendance where UserID=' + gvStaffDetails.SelectedRow.Cells[2].Text.ToString().Trim() + ' and datename(monthprocessdate) =' + Session[paymonth] + ' and datepart(yyyyprocessdate)=' + Session[payyear] + ' and Overtime_HHMM '00:00:00.0000000'; string strtotminutes = SELECT totalovertime = CONVERT(TIME DATEADD(s total_sec 0))FROM Accounts_DailyAttendance; cmd = new SqlCommand(str con); cmd = new SqlCommand(strtotminutes con); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); lbltotalovertime.Text = reader[totalovertime].ToString(); reader.Close(); con.Close(); } Thanks

Vulpes · Answer

Well if the integer is supposed to represent the amount of overtime in seconds then 59400 is actually equivalent to 16:30:00 rather than 22:03:00. Anyway to convert it to a time period using C# you can use this code: cmd = new SqlCommand(str con); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); int seconds; int.TryParse(reader[total_sec].ToString() out seconds); DateTime dt = DateTime.Today.AddSeconds(seconds); lbltotalovertime.Text = dt.ToString(HH:mm:ss.fffffff);

Vulpes · Answer

Incidentally if there's a possibility that the total overtime could equal or exceed 24 hours then I'd use this code instead otherwise the 'days' portion will be lost: cmd = new SqlCommand(str con); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); int seconds; int.TryParse(reader[total_sec].ToString() out seconds); TimeSpan ts = TimeSpan.FromSeconds(seconds); string period; if(ts.Days == 0) { period = ts.ToString(@hh\:mm\:ss\.fffffff); } else { period = (ts.Days * 24 + ts.Hours) + ts.ToString(@\:mm\:ss\.fffffff); } lbltotalovertime.Text = period;

Riddhi Valecha · Answer

Hi.. I would suggest that you also store a date in separate variable. Steps- 1.Take a variable and also store the date it in. 2.Instead of converting the C# integer value to date time just display that variable. Your code will not be visible to the users.