Re: [SQL] subtract a day from the NOW function - Mailing list pgsql-general

From John Meyer
Subject Re: [SQL] subtract a day from the NOW function
Date
Msg-id 4668DECC.3090505@gmail.com
Whole thread Raw
In response to Re: [SQL] subtract a day from the NOW function  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] subtract a day from the NOW function
Next
From: Zoltan Boszormenyi
Date:
Subject: What's the correct way to use FunctionCallInvoke()?