Post date time not updating after Timezone change

[nazmulhudadev]

Please create a post first and check the date time from Dashboard post list view. Assume, it's 1:30pm.
Now, change the Timezone from the settings and check the previous post date time again and you will see the time is not updated.

I would expect that the published date would reflect the timezone change

[welcher]

Date in post list view that is not updating after the timezone change

[welcher]

Created at WCAsia 2023 contributor day

[welcher]

Possibly related #52501

[hztyfoon]

timezone changing doesn't apply for older posts

[hztyfoon]

I've also checked it from WCAsia 2023 contributor day & also found it on my end.

In the screenshot I shared:
the 2 posts was created within 2 minutes but before publishing the 2nd post the timezone was changed from 'UTC' to 'utc+7' but only the 2nd post's timezone changed but not the posts published before that.

I think all the post should be changed/converted to the new timezone.

Trac ticket: https://core.trac.wordpress.org/ticket/57742

When we change GMT & click on save changes then all the post Date updated automatically based on the currently selected Timezone.

Trac ticket: https://core.trac.wordpress.org/ticket/57742

[sakibmd]

I have also checked @nazmulhudadev's PR and it's working great.

[hasanmisbah]

I've tested @sakibmd's patch and @nazmulhudadev's PR both are working fine. thanks for your contribution.

[welcher]

This is great! The code looks fine to me. I took a brief look and didn't see any unit tests for the column_date function - do we need to add them?

Maybe one of the core committers who attended contributor day would be open to reviewing it as well? @adamsilverstein @desrosj @mikeschroder