I see wordpress database on wp_posts
table, there are 2 columns to store post date, post_date
and post_date_gmt
post_date_gmt
store the post date in GMT time. And post_date
store post date in user time who create the post. Am I right?
Is there any benefit to store both version of post date on database?
Is it faster to store both version of post date rather than calculate post_date_gmt
with user timezone when user want to view post date based on his/her timezone
UPDATE: I Also ask on site point and get this answer
The one benefit it would provide is that if the person moves to a different timezone then their earlier posts still record what time it was where they were when they posted them and not what time it was where they are now (as would be all you could calculate using the GMT time and their current timezone).