Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]

Поиск
Список
Период
Сортировка
От David Harper
Тема Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]
Дата
Msg-id 8B4735A4-7B46-406A-B4F1-CBFA47D5E1BC@sanger.ac.uk
обсуждение исходный текст
Ответ на Re: Ambiguous language in Table 8.13. Special Date/Time Inputs  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
> 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
recommmendsthe 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/timeis referred to as "at midnight on Friday, October 20th" the intention could be either midnight the beginning
ofthe 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,
usingthe designation of 0000 to refer to midnight at the beginning of a given day (or date) and 2400 to designate the
endof 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?

David Harper

Wellcome Sanger Institute, Cambridge, England

--
 The Wellcome Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.



В списке pgsql-docs по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Postgres 11: Table Partitioning and Primary Keys
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Ambiguous language in Table 8.13. Special Date/Time Inputs [EXT]