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. How do I display posts by day?
  39. Serve visitor post time adjusted to their timezone
  40. Fixing UTC time – wordpress effects
  41. How to check for WordPress timezone type?
  42. Echo Messages By Checking current_time()
  43. custom field value date convert to unix timestamp problems
  44. How would I bulk change posting date?
  45. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  46. Query by custom dates in UNIX Time
  47. If else statement based on date_diff value
  48. How do I create a dynamically-updated copyright statement?
  49. How do you format the date as a two digit year? (ex. “10.12.10” instead of “10.12.2010”)
  50. How can I display the current time? [closed]
  51. 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?
  52. Creating a function within functions.php to change the date
  53. Calculate future date
  54. date() returns incorrect value if used from WordPress theme, but correct otherwise
  55. How to get date using timezone saved in options? [duplicate]
  56. php console log speed [closed]
  57. display month in french in wordpress/php?
  58. Change wordpress current_time function to different timezone
  59. Timezone UTC to PST
  60. How do I set up my blog home page to show only this weeke’s posts automatically?
  61. Randomised Post Time
  62. Make WordPress use timezone for email Date header
  63. Trouble Formatting DateTime
  64. Placed on + only date (not time)
  65. Display date and time in comments
  66. Time Issue xx hours ago
  67. Get WordPress current date/time
  68. Separately formatting date elements
  69. Show the_date with link
  70. Displaying time & date problem
  71. Translate current_time
  72. Should I escape the attributes when using get_month_link?
  73. Time & Date on Post – Time Ago Custom Function
  74. How do I make a page not visible at a certain time? [closed]
  75. wordpress blog posts’s time
  76. Display posts starting from today date
  77. Separating publish date and last modified
  78. Compare date fails when date is in next year [closed]
  79. How to setup language of a date in a plugin
  80. How to show different timestamp
  81. Problems with the_time,the_date, get_the_time
  82. Comparing Time with the_time();
  83. Date time doesn’t show correctly in qTranslate [closed]
  84. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  85. Timed post and tweet?
  86. wp_dropdown_categories by date?
  87. How to detect and handle the time difference between server and user in WordPress?
  88. WordPress Translate Date Function is giving Error
  89. current_time function incorrect in plugin and PHP, not in WordPress admin
  90. Apply filters on date format
  91. How to fix mysql2date() for 5.3.2 version?
  92. Count time from registration date to today
  93. Update existing post times to random times?
  94. Incorrect display of bbpress forum topics & replies
  95. Can’t add to time? [closed]
  96. Render the published date/time formatted in ISO 8601 using Timber (.twig)
  97. Change the year of the whole site
  98. datetime picker, timestamps and meta queries
  99. Display datetime in user’s timezone
  100. Get current week’s day and time outside the loop
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)