SQLite Forum

How to convert am/pm time to 24hrs time format
All true. This is why I labelled it "intuition" instead of "logic". I really didn't mean to come off as talking down about others views (though clearly they are wrong when they do not conform to mine). #haha

In my mind, it makes more sense that the "am pm" designation goes with the hour of the day. That being said, it is already non-intuitive that 12 maps to 0 and 12 and 24.

Intuition and logic are different things, even though people tend to conflate them. Hence my sincere thanks for pointing out that my intuition doesn't match others and thus that I need to be more precise when communicating the "round hours" of "exactly" noon and midnight.