Time diff

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  January 14, 2008 at 3:55 am

  #119681

  Hi

  Can anyone help me in taking the difference between two times in a query.Have to take the data from the datetime datatype.

  Thanks in Advance

• JWOL

  Hall of Fame

  Points: 3471

  More actions

  January 14, 2008 at 4:43 am

  #767621

  Look up the DATEDIFF function on MSDN.

• free_mascot

  One Orange Chip

  Points: 27169

  More actions

  January 14, 2008 at 5:13 am

  #767630

  Check following link:

  http://msdn2.microsoft.com/en-us/library/ms189794.aspx

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• Carolyn Sellers

  SSC Veteran

  Points: 259

  More actions

  January 15, 2008 at 2:49 pm

  #768353

  Dude, check this out:

  http://www.sql-server-performance.com/articles/dev/datetime_datatype_p1.aspx

  This is most informative in dealing with SQL 2000/2005 datetime nuances

• rbolar

  Grasshopper

  Points: 13

  More actions

  January 16, 2008 at 7:37 am

  #768652

  These sites might help you:

  http://www.sqlteam.com/article/datediff-function-demystified

  http://www.eggheadcafe.com/community/aspnet/13/10010433/how-to-calculate-last-log.aspx

  or might be this one will help:

  http://www.eggheadcafe.com/software/aspnet/30238367/datediff-problem.aspx