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?
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
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
