date in terms of HH:MM:SS?

Question

Hi........

I have two date startdate 05/14/2012 12:25:00 and enddate 05/15/2012 23:21:00 like this ,
i need diffrence of this time in terms of HH:MM:SS Please suggest.......................

Thanks in advance

Senthilkumar · Answer

Hi Santhosh Try this... DECLARE @StartDate DATETIME = '2010-06-10 18:51:31.410'  @EndDate DATETIME = '2010-06-10 09:33:31.110' SELECT CONVERT(VARCHAR(14)@StartDate-@EndDate108) AS 'HH:MM:SS'

Pravinkumar Birajdar · Answer

try this code.......... private void button2_Click(object sender EventArgs e) { TimeSpan ts; ts = Convert.ToDateTime(dateTimePicker2.Value).Subtract(Convert.ToDateTime(dateTimePicker1.Value)); label1.Text = ts.ToString(); }