Can someone explain why wordpress uses two column for storing time values?

The post_date is the post_date_gmt after the Timezone value (in Settings) has been applied.

So, if you like, the reasoning is that there’s a standard time for everybody, and then your own site’s time depending on your Settings, so say you want to change that later, the standard time is always left untouched.

Related Posts:

  1. Is it safe to use ‘date_default_timezone_set’ in plugin file?
  2. filter date and time to differents time zone
  3. WordPress outputs mm/dd but it should be opposite
  4. timestamp and scheduled post irregularities
  5. Default timezone hardcoded as UTC?
  6. How to convert DateTime() to display time based on WordPress timezone setting?
  7. Why time functions show invalid time zone when using ‘c’ time format?
  8. Date, Time, and Timezones
  9. Finding difference in days
  10. How to get time difference between publish date and now?
  11. Relative time – how to calculate difference beween post publish date and current time
  12. UTC/local time in Worpdress
  13. Convert CST published date time to MST timezone
  14. How can i display time minus 6 hours
  15. Display time as “12:00 noon” instead of “12:00 pm”
  16. How get exact time difference
  17. Where does the time get pulled from in the_time()
  18. Human time difference in months instead of days. How?
  19. Why do I need to set my PHP timezone when it’s already set in WordPress?
  20. How to get User Time Zone in WordPress?
  21. Default Timezone setting in WordPress – is that global?
  22. admin end post published time display not working correctly
  23. Timezone for Plugin
  24. How to get Unix Local Time?
  25. Calculate how much time passed comparing WordPress comment and current time
  26. Date is showing in unreadable format. How to convert to readable date?
  27. How to get WordPress Time Zone setting?
  28. Proper formatting of post_date for wp_insert_post?
  29. What’s the difference between get_the_time and get_the_date?
  30. When does next Cron Job run (time from now)?
  31. PHP function showing wrong time in WordPress
  32. Running WP Cron on specific local time
  33. Whats the way to format a date after using get_posts()
  34. Converting Unix timestamp to wordpress date
  35. What is the best workaround for supporting all existing DATEs?
  36. Date format with genitive case of the month name is not working
  37. datetime picker, timestamps and meta queries
  38. Serve visitor post time adjusted to their timezone
  39. Fixing UTC time – wordpress effects
  40. Echo Messages By Checking current_time()
  41. custom field value date convert to unix timestamp problems
  42. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  43. Query by custom dates in UNIX Time
  44. If else statement based on date_diff value
  45. How do I create a dynamically-updated copyright statement?
  46. How do you format the date as a two digit year? (ex. “10.12.10” instead of “10.12.2010”)
  47. How can I display the current time? [closed]
  48. I get “The PHP Date/Time library is not supported by your web host.” on my CentOS host, what library to I need to install to add support?
  49. Creating a function within functions.php to change the date
  50. Calculate future date
  51. date() returns incorrect value if used from WordPress theme, but correct otherwise
  52. php console log speed [closed]
  53. display month in french in wordpress/php?
  54. Change wordpress current_time function to different timezone
  55. Timezone UTC to PST
  56. How do I set up my blog home page to show only this weeke’s posts automatically?
  57. Randomised Post Time
  58. Make WordPress use timezone for email Date header
  59. Trouble Formatting DateTime
  60. Display date and time in comments
  61. Time Issue xx hours ago
  62. Get WordPress current date/time
  63. Separately formatting date elements
  64. Show the_date with link
  65. Displaying time & date problem
  66. Translate current_time
  67. Should I escape the attributes when using get_month_link?
  68. Time & Date on Post – Time Ago Custom Function
  69. wordpress blog posts’s time
  70. Display posts starting from today date
  71. Separating publish date and last modified
  72. Compare date fails when date is in next year [closed]
  73. How to show different timestamp
  74. Problems with the_time,the_date, get_the_time
  75. Comparing Time with the_time();
  76. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  77. wp_dropdown_categories by date?
  78. How to detect and handle the time difference between server and user in WordPress?
  79. WordPress Translate Date Function is giving Error
  80. current_time function incorrect in plugin and PHP, not in WordPress admin
  81. How to fix mysql2date() for 5.3.2 version?
  82. Count time from registration date to today
  83. Update existing post times to random times?
  84. Incorrect display of bbpress forum topics & replies
  85. Can’t add to time? [closed]
  86. Display datetime in user’s timezone
  87. Get current week’s day and time outside the loop
  88. Pull ‘Popular Posts’ within specific timeframe
  89. How to display time when page is created and edited
  90. Block post updates and deletion after a set period
  91. Replicate the_date function when using a custom field
  92. How to second orderby in “pre_get_posts” by meta value or combine single date and time to timestamp
  93. Time sort with meta_key using UNIX timestamp failing due to date differences
  94. Change the counter in terms of date
  95. Comment time is same as the post time
  96. Query sub subpages based on specific date?
  97. Adding a class to last post in the_date
  98. Get system timestamp in wordpress
  99. Standard API for rendering a date form
  100. Display the last date, regardless of articles