BUG #3252: Select Order by time

["Lee Chua" <leehchua(at)bensecurity(dot)com(dot)au>]

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.