Jonathan Feally wrote: > Is anyone experiencing an issue with the internal date being returned > wrong for messages on IMAP? > I am running FreeBSD, MySQL 5.1 delivered via postfix LMTP. Date on db > row is corrected for TZ from -0800 (local machine time and zone) to > +0000, but when recalled it is taken as is and the -0800 added to it, > thus my PPC phone shows all emails as received as of +0000 time because > it TZ is matching that of the client. > > I'm thinking that the correct internal date to be stored in the database > is the TZ=0000 adjusted time. So it would appear that either the > date_sql2imap(), which is only called to translate the db date to imap > format is expecting the date retrieved to be local time and use the > local tz. > > So which TZ should the date be stored in?
GMT we're relying on g_mime_utils_header_decode_date to give us the GMT time equivalent. Maybe I misunderstood some of the issues involved here, but this is the first complaint in years, so it could be something bsd specific. > > I've worked around the problem by making it return +0000 instead of the > local tz, but is this the correct way that we should solve this issue? > > -Jon > -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
