i've got a database that inserts records with a time field in the format MM/DD/YYY, instead of a standard timestamp. (i know, i know... but unfortunately i didn't write the original code.) i'm trying to pull the records back out via PHP with a statement like the following, based on a time i'm setting with an earlier form ($criteria_time): PHP: SELECT a, b FROM table WHERE record_time > '$criteria_time' and i've been playing with things like: PHP: $criteria_time = date('n/j/Y', (mktime(0, 0, 0, $month, $day, $year))); which puts my starting date into a format that matches the one in the database. but i'm having no luck in getting it to work; it just returns every record in the table. does anyone know how i should be doing this? i figure i need to tell mySQL to evaluate record_time and criteria_time as dates and not just strings, but i don't know how to do this. any and all help appreciated.