SQLite Forum

SQL query help for between times and grouping times
Personally I'd be asking them to convert to storing date and time in one column, the number of seconds since the epoch. That way you properly separate data storage from data presentation and comparisons then become trivial and comprehensible.