Re: [SQL] subtract a day from the NOW function

Поиск
Список
Период
Сортировка
От John Meyer
Тема Re: [SQL] subtract a day from the NOW function
Дата
Msg-id 4668DECC.3090505@gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] subtract a day from the NOW function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Kevin Hunter <hunteke@earlham.edu> writes:
>
>> At 5:57p -0400 on 07 Jun 2007, Michael Glaesemann wrote:
>>
>>> It is a bit tricky. Datetime math is inherently so.
>>>
>
>
>> So one wonders why the whole world doesn't migrate to a single timezone.
>>
>
> Or at least get rid of daylight savings, which has to be one of the
> worst ideas of the last 200 years ...
>

You mean we don't have to worry about defeating Jerry and the Kaiser
anymore?  Boggles the mind.
Seriously, as long as everybody's in agreement, stick to UTC and let the
local software developers worry about formatting conversions to and from
for display.

--
The NCP Revue -- http://www.ncprevue.com/blog


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] subtract a day from the NOW function
Следующее
От: Zoltan Boszormenyi
Дата:
Сообщение: What's the correct way to use FunctionCallInvoke()?