Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    52

    Unhappy Unanswered: date query problem in query analyzer

    i tried to check my query in query analyzer even then its not giving the correct answer.
    the query is

    select status from t_auction where endDate > 12/5/2003

    it gives me all four result and if i change greater than sign with less than then no result

    heres the end dates
    11/23/2003
    11/27/2003
    12/6/2003
    12/24/2003
    Last edited by waqas; 12-02-03 at 04:30.

  2. #2
    Join Date
    Oct 2003
    Location
    Manila, Philippines
    Posts
    20

    Re: date query problem in query analyzer

    Originally posted by waqas
    i tried to check my query in query analyzer even then its not giving the correct answer.
    the query is

    select status from t_auction where endDate > 12/5/2003

    it gives me all four result and if i change greater than sign with less than then no result

    heres the end dates
    11/23/2003
    11/27/2003
    12/6/2003
    12/24/2003
    Just enclose your date to a single quote
    like
    select status from t_auction where endDate > '12/5/2003'

    and then try again...


    -bernie

  3. #3
    Join Date
    Jan 2003
    Posts
    52

    Smile

    thanx

Posting Permissions

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