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