From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | David Harper <adh(at)sanger(dot)ac(dot)uk> |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT] |
Date: | 2019-07-09 15:48:25 |
Message-ID: | 20190709154825.egarmx2s5jyvft4e@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Tue, Jul 9, 2019 at 09:14:27AM +0100, David Harper wrote:
> > Uh, I believe midnight is always the start of the day.
>
> The U.S. National Institute of Standards and Technology (NIST) deprecates the term “midnight” as ambiguous and recommmends the use of 24-hour clock notation:
>
> ===== BEGIN QUOTE =====
> When someone refers to "midnight tonight" or "midnight last night" the reference of time is obvious. However, if a date/time is referred to as "at midnight on Friday, October 20th" the intention could be either midnight the beginning of the day or midnight at the end of the day.
>
> To avoid ambiguity, specification of an event as occurring on a particular day at 11:59 p.m. or 12:01 a.m. is a good idea, especially legal documents such as contracts and insurance policies. Another option would be to use 24-hour clock, using the designation of 0000 to refer to midnight at the beginning of a given day (or date) and 2400 to designate the end of a given day (or date).
> ===== END QUOTE =====
>
> Source:
>
> https://www.nist.gov/pml/time-and-frequency-division/times-day-faqs
>
> > I think 00:00:00 looks awkward.
>
> Perhaps, but in technical documentation, accuracy should have priority over aesthetics, surely?
>
Yes, I see what you mean now. How is this patch, which uses "zero
hour"?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
Attachment | Content-Type | Size |
---|---|---|
zero.diff | text/x-diff | 1.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-07-09 15:58:35 | Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT] |
Previous Message | David Harper | 2019-07-09 08:14:27 | Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT] |