I am using Sawmill 8.5.9 connected to a MySQL database with an Ironport C-Series profile. When I set up a new profile, build the database, update the database once, everything is OK. But when I schedule an update database or execute it manually, Sawmill writes future dates in date_time always with a 00:00:00 time stamp.
I have already analyzed the raw logs and there is no date_time like this stored. When I filter a message to multiple recipients by message ID I can see that to one recipient the date_time is correct while to the other it has that future date_time.