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

Tom Lane wrote:
> Kevin Hunter <hunteke(at)earlham(dot)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