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.
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.