The confusion arose from the inconsistency introduced by epoch. I would have expected an error when returning an invalid time like 00:00:000 PM. It would certainly be handy to have a time of day type for situations like this considering databases, .net etc. support for time versus datetime is inherent. Any suggestions with what we do have that is a little cleaner than this current method?
Basically I need to evaluate a regular time each day to perform an action and the database is storing time.
