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 with meta values as serialize arrays
  9. Use REGEXP in WP_Query meta_query key
  10. compare meta_query in get_posts arguments
  11. Display products from specific category in shop page
  12. How to Compare Two Meta Fields
  13. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  14. Getting attachments by meta value
  15. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  16. Query by meta_key and order by meta_value_num return orderby date
  17. WP_Query not working as expected for attachments and custom meta_query
  18. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  19. Wp_query order by multiple custom fields?
  20. List taxonomy terms plus their latest post ordered by post date
  21. WordPress altering my custom query, How to fix it?
  22. How to query ‘posts_per_page’ to display a different blog posts index template?
  23. Order by meta_key in custom post type doesn’t affect the query
  24. How to create/modfiy WP_Query to search in post title OR custom field?
  25. Order By Multiple Meta Fields
  26. Advanced WP Query hogs the SQL server
  27. How to get user_id from wordpress database inside ajax function?
  28. Multiple meta queries but arrange by specific meta value order
  29. Order Posts by meta value AND published date
  30. WP_Query with multiple meta fields filter?
  31. How to combine meta_query and post__in in WP_Query
  32. What format does the meta_query TIME type require?
  33. How to orderby meta_value_num with dollar ($) sign
  34. pre_get_posts order by not working
  35. WP_Query filter and order by meta ordering by wrong joined table
  36. WP_Query last five posts, simply ordered by meta_value
  37. What is the random string I am seeing when I use get_query_var?
  38. Fetch Record based on meta key dates
  39. meta_query in WP_Query value is not accepting array
  40. Changing sort order for presentation by Jetpack infinite scroll
  41. meta_query not working as expected
  42. get posts by meta_key from inside key of post meta
  43. Help optimizing slow WP_Query with meta_query
  44. meta_value_num not ordering all items
  45. Meta Queries – should nesting work after WP 4.1?
  46. Filter and Order by Multiple Custom Meta Values
  47. Meta Query relation “AND” then set array accordingly
  48. Query with meta_query and tax_query together not working properly
  49. Array as ‘key’ in WP_Query
  50. Is it possible to query a custom field where the value is between two fields?
  51. How to provide meta_key array to wp_query?
  52. Searching for meta_key returns 0 posts
  53. meta_query fails to compare on values containing apostrophes
  54. How to set up hierarchical relationships without using plugins / meta query
  55. Check if searched number is within the post meta value
  56. Meta query compare for ID’s greater than specific ID
  57. Is it possible to add relation between meta_query and tax_query?
  58. add_query_arg to compare and display events from a certain date
  59. Show single posts date, in a page of posts
  60. WP_Query Class custom field parameters
  61. WP_Query not returning correct result with meta_query parameter
  62. meta_query where the meta value is not the post title
  63. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  64. How do i create a custom post query when the meta value is an array?
  65. Custom Meta Query doesn’t work the same on two site
  66. meta_query with meta values as serialize arrays
  67. WP Query – grouping posts by same meta key, adding together values from another key
  68. Woocommerce Get Orders By Meta Value
  69. meta_query is overriding default search
  70. Multiple WP_Query args combinations according to post type
  71. WP_Query multiple value not working
  72. How to do WP_User_Query for Nested Array value Inside Nested Array field
  73. Query for current post
  74. Custom query to retrieve oldest post and retrieve others with date interval
  75. WP_User_Query Orderby Not Working
  76. Unusual high query of user meta data
  77. Very slow query generated getting meta data from posts
  78. WordPress Query optimaization for slow query
  79. How to filter on placeholder image
  80. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  81. Meta query doesn’t remove placeholder escape before query
  82. WP_Query with meta_query won’t orderby
  83. meta_query only check if both value are set
  84. What is the best way to reset a search on a meta_key / meta_value?
  85. Slow query when selecting with large meta query or post__in
  86. WP Meta Query at depth 2
  87. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  88. Using custom field as ‘orderby’ value causing post grouping by publish date
  89. Is there any difference between below WP_Query code snippets?
  90. Using WP_Query to re-query and sort results using a date?
  91. Sorting: custom query with orderby meta_value_num THEN by title
  92. meta_query compare not doing what I want it to do
  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