SELECT dates not equal to 0

run_GMoney

I've got a date row in a table, we'll call it games, that stores some dates. I'd like to SELECT all of the dates in this row that are not equal to 00-00-00. I tried a SELECT statement like this:

$sql = "SELECT games FROM datetable WHERE games <> '0000-00-00'";

However I get a parse error when I execute it. So, am I missing something simple here in my syntax or something? Thanks

paul088

I guess you may need to convert the data to timestamp since 00-00-00 is not in a normal numerical format for comparision.

paul088

Or try

where games IS NOT NULL

run_GMoney

I would think there would be some way to perform a comparison on a date field, though.

FYI - I tried the IS NOT NULL thing. Thought that would work but unfortunately it did not. Thanks for the suggestion though

run_GMoney

Alright, I'm officially dumb. We'll just call my mistake an "oversight." There was nothing wrong with the SQL statement.

$sql = "SELECT games FROM datetable WHERE games IS NOT NULL";

Worked like a charm. Ironically enough, I had a syntax error on a line that was supposed to do error checking. Thanks again