Query using today.

• El barto

  Ten Centuries

  Points: 1072

  More actions

  January 12, 2006 at 8:38 am

  #170549

  Hello all,

  I have an issue that if possible I would like some assistance with.

  I am attempting to select records from a table using a date column where the date is greater than today. Could you possibly let me know the SQL syntax for this.

   

  Many thanks.

   

   

  ---

  Kindest Regards,

  Nick

• Mike Metcalf

  SSCrazy Eights

  Points: 8763

  More actions

  January 12, 2006 at 9:45 am

  #614414

  here's a quick and dirty method that i've used on occasion,

  where date >= left(dateadd(d, 1, getdate(), 11)

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  January 12, 2006 at 10:02 am

  #614426

  ...or...

  select * from myTable where datediff(day, getdate(), dateColumn) > 0
  

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**