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 with meta values as serialize arrays
  10. Nested meta_query with multiple relation keys
  11. meta_query ‘compare’ => ‘IN’ not working
  12. Use REGEXP in WP_Query meta_query key
  13. WP Query Args – Title or Meta Value
  14. Meta query with string starting like pattern
  15. compare meta_query in get_posts arguments
  16. How to query posts based on lat-lng coordinate as post meta?
  17. how to show posts that are missing a meta_value
  18. How to show all the associated posts with specific date of data metabox?
  19. WP_Query – show posts where meta value and user_email match
  20. WP Meta Query at depth 2
  21. Best way to Order Post in Home without a plugin
  22. WP_Query returns empty if meta_query has more than 7 values
  23. Is it possible to search for a string in posts OR postmeta?
  24. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  25. meta_query not working with the_content()
  26. WP_Query using meta_query with LIKE doesn’t return what it should
  27. Using custom field as ‘orderby’ value causing post grouping by publish date
  28. Use not custom fields in get_posts() meta_query?
  29. Filter posts/pages by user_role array
  30. WP_Query with MetaQuery issue
  31. WP_Query Posts by Metadata from Option Tree
  32. Custom loop – Isolating post meta output depending on current query taxonomy terms
  33. Compare meta key separation
  34. WordPress meta_query not working
  35. Using orderby with 2 meta keys
  36. Is there any difference between below WP_Query code snippets?
  37. Get closest event where meta_key field is an array
  38. Using WP_Query to re-query and sort results using a date?
  39. WP_Query with meta_value_num and meta_query not paged correctly
  40. Post Query not working after updating to 4.1
  41. Orderby Meta Value and Query from Meta Query
  42. Return a single custom post from multiple meta queries
  43. Selecting posts older than the current Unix epoch timestamp
  44. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  45. WP_Query Sorting Posts by month … timeline effect
  46. Set right order for query that returns posts based on two custom fields
  47. Sorting: custom query with orderby meta_value_num THEN by title
  48. Sort posts in dashboard using custom field; also include posts where field isn’t set
  49. Passing conditional arrays to WP_Query() [closed]
  50. query post based on comparison
  51. WordPress Query Default Order if Meta Values Same?
  52. Time sort with meta_key using UNIX timestamp failing due to date differences
  53. Sort Posts with custom meta key by default which is currently set as optional
  54. Meta_query weird behaviour
  55. Why is WP_Query’s meta_query not filtering results?
  56. Including ‘cat’ => $cat breaks meta_query
  57. meta_query compare not doing what I want it to do
  58. Looking for a way to exclude frontpage and nav menu from query filter
  59. WP_Query with several meta_query-statements and order by meta_value
  60. Custom query (author is post_author or meta co_author) with Pagenavi pagination
  61. Creating Custom Query
  62. Query string form $_GET[‘value’] is not working as meta value in wp_query
  63. Can’t figure out query logic
  64. WP_Query orderby not working on custom post_type
  65. Wp query by 2 meta field – check if they exists / have value
  66. meta_query in wp_query not working as expected
  67. 294 Queries on Mainpage of WordPress
  68. Get posts by meta value except one post [closed]
  69. Get all user with both meta_value
  70. WP_Query by meta key not returning any posts
  71. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  72. WordPress extremely slow when using get_posts with multiple meta_query relations
  73. How do I have multiple metaqueries inside one wordpress query
  74. How to get all post_id and meta_value using meta_key in wp_postmeta table
  75. WP query with multiple custom meta not respecting orderby
  76. Get posts using multiple values from ACF checkbox as meta query wordpress
  77. WP Query – Show custom posts only if user contain some user meta
  78. How do I subquery with custom meta fields?
  79. get_post_meta bringing back results, but $wpdb->postmeta doesn’t
  80. Use meta query only 3 or more results?
  81. Why does wp_query only display the most recent post when using order ASC?
  82. Showing Counts on Comment List with Custom Query
  83. Custom query with custom filtering returning incorrect results
  84. WP Query returning all posts when Meta_query is null
  85. Display only posts with thumbnails
  86. Use value from meta key array for use in WP_Query
  87. WordPress – Optimize the Meta Query for 3 meta keys at a time
  88. Passing a variable containing a comma separated list of values in a meta-query
  89. Complicated `orderby` based on text in custom field
  90. meta_query post_date not returning results
  91. WP Query: orderby with one meta key, but multiple values
  92. How to use meta_query to retrieve posts from multiple custom post type
  93. How to get products with the same custom attribute like ean code
  94. WP_Query filtering in ACF field containing dates
  95. Multiple meta value orderby clauses in a WP_Query
  96. WP_Query: how to sort all posts by date when one category has a custom “date” field?
  97. get_meta_sql hook is not firing
  98. Post Query with Meta Query no longer working
  99. Problem making a WPQuery with ACF boolean
  100. Order by multiple custom fields within woocommerce hook for catalog ordering (woocommerce_get_catalog_ordering_args)
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)