How to compare server current time and my table time

• kelvin00522

  Newbie

  Points: 1

  More actions

  November 29, 2009 at 8:35 pm

  #228186

  Dear ALL

  I would like to write a query to compare my table colume date+ time with server current time.

  For example server current time > table column time 30 mins then will query the result

  Can you guys please give me some idea ?

  Thanks bros

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  November 29, 2009 at 9:25 pm

  #1085226

  I hope this would work, add the following code in your query and change the name of the DateColumn.

  where Getdate() > Dateadd(mi,30,DateColumn)

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty