datetime picker, timestamps and meta queries

WordPress sets the php timezone to UTC for internal calculations. So at 4pm PST, date() will be producing a date that reads 10pm UTC. Hence the event is considered past.

There are two ways to resolve this.

  1. (The preferred method) Store dates in the database in UTC. Handle all date calculations in UTC, and convert to the desired timezone on output (frontend and back).

  2. Use date_i18n()for creating the date to query (as this will set the date according to your blog timezone).

Related Posts:

  1. datetime picker, timestamps and meta queries
  2. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  3. Use meta_query to display events by date in custom field
  4. Query by custom dates in UNIX Time
  5. 2 weeks ago from meta query meta value
  6. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  7. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)
  8. Meta_query compare operator explanation
  9. meta_query ‘compare’ => ‘IN’ not working
  10. Sorting: custom query with orderby meta_value_num THEN by title
  11. WP_Query with checkbox meta_query
  12. Add indexing to meta_value in wp_postmeta
  13. Custom WP_Query order by post_meta and (author) user_meta
  14. WordPress Custom Query to show posts from last x years
  15. Perform query with meta_value date
  16. Meta Query with date and time on the same Day before given time
  17. How to grab metabox value in wp_query meta_query key
  18. How can I create a WP_Query that returns posts where one meta_value
  19. WP Meta Query for some meta (array) values
  20. Sort users by meta_value_num
  21. meta_query with array as value
  22. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  23. Using WP Query to search within ALL keys in meta query
  24. WP Query – Get WooCommerce Products with variation that is in stock
  25. Meta_query with or without value
  26. Date query not inclusive despite parameter being true
  27. wp_query not searching with apostrophe
  28. Add condition of user capability in WP_query
  29. Custom query based on meta key – Reduce three states to two in results?
  30. How to make Meta Query case sensitive?
  31. Performance when getting post meta for post retrieved by meta value
  32. Any number in meta key (wp query)
  33. How to display multiple custom fields with the same meta_key in an ascending order?
  34. Meta_query with multiple keys and multiple values
  35. Is it a good idea to improve meta query performance by adding tax query?
  36. Modify wp-query and sort by post meta key
  37. Tax query AND/OR meta query [duplicate]
  38. Orderby listing issue
  39. Help ordering Post loop by two meta values
  40. Query posts with “non set” meta value
  41. Query with meta_query and tax_query together not working properly
  42. Array as ‘key’ in WP_Query
  43. Ordering a mysql style datetime stamp with meta_query
  44. Is it possible to query a custom field where the value is between two fields?
  45. Filter posts by comparing custom meta value against postdate
  46. Wp_query with 2 meta keys and array of meta values
  47. meta_query: check if number exists
  48. Searching for meta_key returns 0 posts
  49. Event with multiple dates, display events chronologically
  50. meta_query fails to compare on values containing apostrophes
  51. Check if searched number is within the post meta value
  52. add_query_arg to compare and display events from a certain date
  53. WP Query / Meta Query [duplicate]
  54. Query posts by searching for a string in a meta field
  55. WP_Query not returning correct result with meta_query parameter
  56. Query multiple post types, but different order for each
  57. How to add date_query to meta_query array
  58. Order by the first array within a meta_query
  59. Query ACF relationship field – Comparator IN – Value array
  60. Query on meta values and post title
  61. Combine query in WP_User_Query()
  62. Multiple nested meta queries
  63. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  64. How do i create a custom post query when the meta value is an array?
  65. How can I modify the query by adding to the existing query?
  66. Custom Meta Query doesn’t work the same on two site
  67. WP Query – grouping posts by same meta key, adding together values from another key
  68. How to do WP_User_Query for Nested Array value Inside Nested Array field
  69. Query for current post
  70. WordPress Query custom ordering by temporary variable
  71. Custom query to retrieve oldest post and retrieve others with date interval
  72. Comparing Meta Field date in WPQuery using Meta_Query?
  73. How to create better WP_Query to look for date time which is anywhere between two meta values?
  74. Very slow query generated getting meta data from posts
  75. How to filter on placeholder image
  76. Filtering WP_Query based on wp_postmeta keys values
  77. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  78. Multiple meta_query not working
  79. compare for multiple meta values for same key in wp_query
  80. WP_Query with meta_query won’t orderby
  81. meta_query only check if both value are set
  82. Query 3 meta_key and orderby
  83. What is the best way to reset a search on a meta_key / meta_value?
  84. Slow query when selecting with large meta query or post__in
  85. WP Meta Query at depth 2
  86. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  87. Using custom field as ‘orderby’ value causing post grouping by publish date
  88. Is there any difference between below WP_Query code snippets?
  89. Using WP_Query to re-query and sort results using a date?
  90. Sorting: custom query with orderby meta_value_num THEN by title
  91. meta_query compare not doing what I want it to do
  92. Looking for a way to exclude frontpage and nav menu from query filter
  93. Creating Custom Query
  94. Can’t figure out query logic
  95. WP_Query orderby not working on custom post_type
  96. Get posts by meta value except one post [closed]
  97. WP_Query by meta key not returning any posts
  98. WordPress extremely slow when using get_posts with multiple meta_query relations
  99. Showing Counts on Comment List with Custom Query
  100. Use value from meta key array for use in WP_Query

Leave a Comment