how to find difference in minutes in SQL

• srikrishnaveni

  Newbie

  Points: 1

  More actions

  August 26, 2008 at 1:02 am

  #189748

  How to find difference in 2 minutes in two tables...

  pls provide query...If i use datediff query it shows only difference in hours not in minutes so kindly provide me....

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  August 26, 2008 at 1:12 am

  #862938

  use Datepart(mi,date1,date2)

  "Keep Trying"

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739701

  More actions

  August 26, 2008 at 3:02 pm

  #863413

  If you have more trouble, please post what you are trying to do and show some work.

  Please post in the appropriate forum. Moved to T-SQL