I'm having trouble with date time in Access with DBI/ODBC

I'm trying to do this:

SELECT * FROM some_table WHERE date_time_field > 11/30/99

That's giving me all dates, where:

SELECT * FROM some_table WHERE date_time_field < 11/30/99

Is giving me none.

I must have done something completely wrong!
It really is a date time field and looks like this: 1998-06-25 00:00:00

Jeff

Reply via email to