Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: SELECT * WHERE [date] > 100 days

    Hi !
    for MS SQL 2000/2000, I need :

    SELECT * FROM table1 WHERE table1.[date] > 100 days

    how can i do that ?

    thank you for helping

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    greater than 100 days?

    that is an incomplete specification

    please try to state in words what you want
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    it works


    UPDATE Users SET status = 3 WHERE (DATEDIFF(day, dInscript, GETDATE()) > 100)

    thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •