24 hour time

Does it make more sense to set 12 AM to 24:00 or to 00:00? Which will cause less trouble for inserting and reading from a database?

To me, it seems more logical to set midnight to 00:00 because it is the switch from PM to AM, thus starting a new day. All digital wrist-watches and clocks that I have ever seen also go from 23:59 to 00:00.

As far as more efficiency in databases, I really don't know.

Hmm. It seems that the database will accept 24:00:00, but will not properly use comparison operaters in the SQL queries (eg.: "SELECT * FROM TableName WHERE Time < '24:00:00'" will not work)

I've seem to come up with a bit of a work around though. Thanks for the suggestion

Proper military time has 00:00 as midnight, so if you're using SQL tools to do the comparison, that's how you should store it.