Help in get date only!!!!!

• Terry-380449

  Default port

  Points: 1458

  More actions

  January 9, 2007 at 9:36 am

  #193835

  I really need help comparing one date to getDate()

   

  The date stored in my db in the format "2007-01-09 17:17:45.810"

   

  i want to compare it to getDate, and when i say myDate >= getDate(), i get not records, why????

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  January 9, 2007 at 9:42 am

  #682066

  DECLARE @demo TABLE (MyDate DATETIME NOT NULL PRIMARY KEY CLUSTERED)

  INSERT INTO @demo (MyDate)

  SELECT DATEADD(D, 1, GETDATE())

  UNION ALL

  SELECT DATEADD(D, -1, GETDATE())

  UNION ALL

  SELECT GETDATE()

  SELECT MyDate FROM @demo

  SELECT MyDate, GetDate() FROM @demo WHERE MyDate >= GetDate()

  --Since all that code is executed at the same time, you should get 2 rows with the final select, if you get only 1 it's because the select was made 3+ ms after the insert

  --wait 1 second

  WAITFOR DELAY '00:00:01'

  SELECT MyDate, GetDate() FROM @demo WHERE MyDate >= GetDate()

  --Now you should see only 1 row.