Shouldn't the Timzone be taken from the environment var TZ as defined by POSIX.1?
-- Wolfram > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Stone > Sent: Mittwoch, 15. September 2004 18:09 > To: DBMAIL Developers Mailinglist > Subject: [Dbmail-dev] Spotty timezone support > > > In the bugtracker I suggested to Ilja that we ask the > database for a fully > formatted date with timezone. We'd basically just write a > no-tables SELECT > query that used a few date functions, one for each database > (we have an > example of this already with some other date handling functions). > > Unfortunately, time zone support is only added to MySQL in 4.1.3 and > higher: > http://dev.mysql.com/doc/mysql/en/Time_zone_support.html > > I haven't looked into PostgreSQL yet, but we'll have to find > a way to work > with MySQL 4.0.x anyhow, so might as well make it all-kludge. > > How about adding a timezone parameter to the config file? > > Aaron > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev
