difference of dates

• tripri

  SSCommitted

  Points: 1584

  More actions

  June 25, 2010 at 3:35 pm

  #222673

  Hi,

  I need to get difference between dates. That is the time difference between todays date and a particular date.

  for xample

  (getdate()-(2010-05-28 13:58:00.000))=xxxxxx minutes

  i tried to figure it out but couldnt. So please help me out with this

• Al-279884

  Old Hand

  Points: 383

  More actions

  June 25, 2010 at 3:54 pm

  #1185290

  check out DATEDIFF on books online

• faheemahmad14

  SSC Veteran

  Points: 266

  More actions

  June 27, 2010 at 10:51 pm

  #1185502

  You can use DateDiff

  like this

  SELECT DATEDIFF(mi,'2010-05-28 13:58:00.000',GETDATE())