BUG #3252: Select Order by time

The following bug has been logged online:

Bug reference: 3252
Logged by: Lee Chua
Email address: leehchua(at)bensecurity(dot)com(dot)au
PostgreSQL version: 8.2.3
Operating system: FC4
Description: Select Order by time
Details:

When we select and order by time we get 00:00:00 as the latest time of the
day.

The latest time of the day should be 23:59:59 not 00:00:00. 00:00:00 should
be the earliest time of the day. This follows naval/military convention
somewhat although the time 00:00:00 actually does not exist in the
military/naval definition and in fact is called Midnight. The only
convention then that we should follow is the computer where we start
counting from 0; so 00:00:00 should be the epoch of the day. It also makes
numerical order sense.