Ok, I've been avoiding dates and such because I get rather mixed up... I have the following select statement:

SELECT eventdate, shortevent FROM bydate where eventdate > 2002-11-06 ORDER BY eventdate ASC

now it's returning
eventdate shortevent
2002-10-24 Men's Cookout
2002-11-26 something

the eventdate field is of type "date." I expect it to just return the second row, because that's the date that is greater than what's in my sql query. Anyone see what's wrong with the statement? or the data?

Thanks
Benny

    Try putting the date in quotes

    SELECT eventdate, shortevent FROM bydate where eventdate > '2002-11-06' ORDER BY eventdate ASC

      I think you forgot to add quotes in select statement:

      SELECT eventdate, shortevent FROM bydate where eventdate >'2002-11-06' ORDER BY eventdate ASC

      Does it work like that?

        Thanks guys, feel pretty stupid after that one.

          Write a Reply...