Re: 'NOW' in UTC with no timezone

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: 'NOW' in UTC with no timezone
Дата
Msg-id 35788438-1C50-11D9-A09B-000A95C88220@myrealbox.com
обсуждение исходный текст
Ответ на Re: 'NOW' in UTC with no timezone  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
On Oct 12, 2004, at 9:43 PM, Karsten Hilbert wrote:

>>>> I'm trying to determine the best way of saying 'The current time in
>>>> UTC
>>>> with no time zone information'.
>>>
>>> Isn't that a contradiction in terms?
>>
>> Not if you're used to the Unix concept of storing "seconds since the
>> epoch".
>> In that model the quantity you're storing is entirely time zone
>> agnostic.
> But then one is storing an interval, not a point in time.

By that logic, all "times" are intervals. '2004-10-12 22:09' is 2004
years, 10 months, 12 days, 22 hours, 9 minutes since 0.

Michael Glaesemann
grzm myrealbox com


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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: 'NOW' in UTC with no timezone
Следующее
От: Jeff Boes
Дата:
Сообщение: Rule uses wrong value