Thread: Re: [SQL] subtract a day from the NOW function
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. There would be no more confusion between EST, CEST, GMT, +1100, etc. The trade off, of course, would be that now you'd have to know the "daylight" hours of a particular part of the world or business with whom you wanted to interact, but the math sure would be easier all-round. Kevin
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 ... regards, tom lane
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