Re: roundoff problem in time datatype

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: roundoff problem in time datatype
Дата
Msg-id 2017792B-EB5B-4275-B771-4AF35599976B@fastcrypt.com
обсуждение исходный текст
Ответ на Re: roundoff problem in time datatype  (Dennis Bjorklund <db@zigo.dhs.org>)
Ответы Re: roundoff problem in time datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Actually, I think there is a case where 24:00 is a proper time. Isn't
it used for adding leap seconds ?

Dave
On 26-Sep-05, at 3:39 AM, Dennis Bjorklund wrote:

> On Sun, 25 Sep 2005, Tom Lane wrote:
>
>
>> Alternatively: why are we forbidding the value 24:00:00 anyway? Is
>> there a reason not to allow the hours field to exceed 23?
>>
>
> One reason is because it's what the standard demand. Another is
> that it
> isn't a proper time, just like feb 31 isn't a proper date.
>
> --
> /Dennis Björklund
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly
>
>



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

Предыдущее
От: "Michael Paesold"
Дата:
Сообщение: Re: "expected authentication request from server, but
Следующее
От: Tom Lane
Дата:
Сообщение: Re: roundoff problem in time datatype