On Fri, 2005-05-13 at 01:49 -0700, Kevin Brown wrote: > Geo Carncross wrote: > > On Thu, 2005-05-12 at 17:08 +0000, Aaron Stone wrote: > > > >> Geo, would you this up as a patch against current dbmail_2_0_branch > > > >> SVN? > > > > > > > > Attached. This means dbmail will mandate GMT/UTC in the SQL-side. > > > > > > Does that change current behavior? I haven't been following the issue yet, > > > as to whether we are keeping dates in the server's local time or in GMT -- > > > is that the entire problem so far? > > > > It can. It depends on the administrator. I recommend the following > > changes to: > > > > Pg driver should to do this somewhat early (after bringing connection > > up): > > SET SESSION TIME ZONE GMT; > > I think to be pedantically correct, this should be UTC, not GMT. I > seem to recall that they're not completely equivalent.
UTC doesn't honor leap seconds. I don't know of any other (earthly) time zone that doesn't, so I still maintain GMT is better for dbmail. -- Internet Connection High Quality Web Hosting http://www.internetconnection.net/
