Date query?

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 when you compare the date time always you need to ensure that you are checking the date time format in equally. Otherwise you need to convert into common format which will solve your business requirement.

brunda k · Answer

convert(smalldatetime'03/30/2012 22:40:00') http://msdn.microsoft.com/en-us/library/ms187928.aspx

Kunal Vaishya · Answer

Dear first try 1955-12-13 12:43:10 Format to convert small date time Date=convert(smalldatetime '2012-12-13 22:40:00') let me know tit work or not

sathish kumar · Answer

yr D m Hr Min Sec DateTime startDate= new DateTime(2005 2 1 3 4  56); DateTime EndDate= new DateTime(2008213412); TimeSpan DiffDate= EndDate.Subtract(StartDate) console.writline(DiffDate.Days.Tostring() + Days); ---DateWise Diff console.writline(DiffDate.Hours.Tostring() + Hours); console.writline(DiffDate.Minutes.Tostring() + Minutes); Tryout this....

Vulpes · Answer

Does it work if you re-express the date in this format? '2012-03-30 22:40:00'