The following bug has been logged online:
Bug reference: 3252
Logged by: Lee Chua
Email address: leehchua@bensecurity.com.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.