It appears that column data type
datetime, just the time of day, for example
12:00) is not supported in
I need to store a time of day, how to work around this?
How should I go about it with the tools and datatypes that are available?
I thought about saving a normal but distinctive date (like
1970-01-01 12:00:00 which is distinctive enough not to be confusing to anyone browsing the data) and just extracting the time part from it in the
UI, but it's horrid and makes me cringe inside.
Is there a more elegant way?