Can someone confirm the intended functionality on this timestamp.
What occurs for me is that the timestamp displayed in the Received column on webmail or ZD (7.1.4) shows the time that the sender sent the message (reflected in my timezone). Not the received time. Selecting "Show Original" from the context menu will, of course, show the senders time and the received time(s) in the header - most importantly from the last (most recent) server. It seems to me that is the "received'" time that should be displayed, and not the senders time.
I can recreate this by back dating the server clock on a different mail server and sending a message to my ZCS FOSS 7.2.0. The client display will show that the message came in hours or even days earlier as if I missed the message some how, but actually it was just received by the server.
Digging around in the database, I confirm this by finding the mail_item record in one of the mboxgroupX databases.
The `date` field and the `change_date` field show the discrepancy to which I am referring.
This query may help.
A discrepancy of a "few" minutes is understandable in the case of an external mail account, but should be no more than the frequency at which Zimbra pulls the mail. In my case every 2 minutes.
if (mb.change_date>mb.date,cast(timediff(from_unixtime(mb.change_date),from_unixtime(mb.date)) as CHAR),'') diff,
FROM zimbra.mailbox m
left join mboxgroup8.mail_item mb ON m.group_id = mb.mailbox_id
order by id desc limit 100;