Calculate Date and Time Difference Between Two Dates

A very common requirement is to display the Date and Time difference between two dates. Let us see how to do it:

C#

   DateTime date1 = 

   System.Convert.ToDateTime("2009-1-01 11:08:22");

   DateTime date2 = 

   System.Convert.ToDateTime("2009-1-02");

   TimeSpan ts = new TimeSpan();

   ts = date2.Subtract(date1);

   Response.Write(ts.Days + " Days " 

      + ts.Hours + " Hours " + 

      ts.Seconds + " Seconds ");        

 // Displays 0 Days 12 Hours 38 Seconds 

VB.NET

   Dim date1 As DateTime = _

    System.Convert.ToDateTime("2009-1-01 11:08:22")

   Dim date2 As DateTime = _

    System.Convert.ToDateTime("2009-1-02")

   Dim ts As New TimeSpan()

   ts = date2.Subtract(date1)

   Response.Write(ts.Days & " Days " & _

     ts.Hours & " Hours " & ts.Seconds & _

   " Seconds ")

 ' Displays 0 Days 12 Hours 38 Seconds 

The output displayed is : 0 Days 12 Hours 38 Seconds

If anyone has a requirement to do the same in SQL Server, check my post over here:

Find Hours, Minutes and Seconds in between two Datetime in SQL Server

Bookmark this link on del.icio.us (saved by 0 users)

Did you like this post?

	subscribe via rss		subscribe via e-mail
	print this post		follow me on twitter

Others Also Read..