Community discussion forum

how to compare date in string

• • Reply

  9 months ago

  by shahid123

  shahid123

  , India

  Joined 1 year ago
  how to compare less then or greater then date in query like select * from status where datedate.today
  Post was edited on 25/02/2009 07:29:09 Report abuse
• • Reply

  8 months ago

  by georgeasfour

  George Asfour

  Vancouver, Canada

  Joined 8 months ago
  select * from status where **yourDBFieldName < GetDate()** It's always better to check also if "yourDBFieldName" is not null before you query. ---------------------------------------------------------------------------------------------------------
  Report abuse