Loading

date in terms of HH:MM:SS?

Santhosh K S

14y1.4k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Accepted 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-@EndDate,108) AS 'HH:MM:SS'
Pravinkumar Birajdar14y ago
        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();
        }