From: | "Lee Chua" <leehchua(at)bensecurity(dot)com(dot)au> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3252: Select Order by time |
Date: | 2007-04-24 18:01:46 |
Message-ID: | 200704241801.l3OI1koB002382@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gary Winslow | 2007-04-24 18:55:18 | BUG #3253: 8.2.4 Installer Displays No Default Install Path and Browse Error 2864 |
Previous Message | William Lawrance | 2007-04-24 16:29:45 | Re: [HACKERS] BUG #3244: problem with PREPARE |