Date in where clause SQL Query

• forum member

  Ten Centuries

  Points: 1290

  More actions

  November 5, 2009 at 6:43 pm

  #227710

  Hi,

  The following is sql query some times i get result of two rows and some times one am i missing someting

  i have two rows in table with 12/11/2009

  but i get randomly one or two rows returned

  SELECT *

  FROM table1

  WHERE Convert(VARCHAR,dbo.table1.StartDateTime,103)=@StartDate

  How can i get correct result,please suggest

  Thanks for the help

• Jeff Moden

  SSC Guru

  Points: 1004582

  More actions

  Follow

  November 5, 2009 at 7:50 pm

  #1075677

  SELECT *

  FROM table1

  WHERE StartDateTime >= @StartDate

  AND StartDateTime < @StartDate + 1

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)