{"id":19014825,"date":"2026-09-08T18:58:28","date_gmt":"2026-09-08T18:58:28","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/date-mismatch-between-database-and-log-list\/"},"modified":"2026-09-08T18:58:28","modified_gmt":"2026-09-08T18:58:28","slug":"date-mismatch-between-database-and-log-list","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/date-mismatch-between-database-and-log-list\/","title":{"rendered":"Date mismatch between Database and Log List"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Version 1.16.0<br \/>Edge on Windows 11.  PHP timezone UTC, database and WordPress America\/Detroit (-4)<br \/><br \/>The plugin stores the emails in local timezone ie timestamp = 2026-09-08 14:11:42, (2:11:42pm) but then shifts the displayed value on the log page by the WP timezone (-4 for me) and adds 4 hours, arriving at 6:11:24pm, 4 hours into the future.  I resolved the issue by modifying the renderer function in wp-mail-logging\\src\\Renderer\\Column\\TimestampColumn.php<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>public function render(array $mailArray, $format) {<br \/>$rendered = parent::render($mailArray, $format);<br \/>$dt = \\DateTime::createFromFormat( 'Y-m-d H:i:s', $rendered, wp_timezone() );<br \/>return wp_date(<br \/>apply_filters( 'wpml_get_date_time_format', '' ),<br \/>$dt-&gt;getTimestamp()<br \/>);<br \/>}<\/code><\/code><\/pre>\n","protected":false},"template":"","class_list":["post-19014825","topic","type-topic","status-publish","hentry","topic-tag-date_i18n"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19014825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/19014825\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=19014825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}