Date comparison

• priyappated-812940

  SSC Veteran

  Points: 224

  More actions

  May 18, 2010 at 6:49 am

  #235191

  I have a table from where i need to retrieve data when datecol < todays date how to do??

  I am writing query as

  "SELECT * FROM TEMPTABLE where TableId=30 AND DAYField < GETDATE()"

  but it is displaying even today's data.

  Please somebody help me.

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  May 18, 2010 at 6:52 am

  #1168779

  Time is intrinsic to the date time type. Please read this... http://www.karaszi.com/SQLServer/info_datetime.asp

  ---

  
  Clear Sky SQL
  My Blog[/url]

• Gopi Muluka

  SSCarpal Tunnel

  Points: 4594

  More actions

  May 18, 2010 at 7:07 am

  #1168788

  use

  DayField < CONVERT(VARCHAR(10),GETDATE(),101)for correct results

• priyappated-812940

  SSC Veteran

  Points: 224

  More actions

  May 18, 2010 at 7:38 am

  #1168812

  Thanks Gopi Muluka

  It worked perfet. Thanks alot