how to compare different timestamps in wp-query for events custom post types?

Looks like a unix timestamp is being stored in the post meta – so you should compare with a unix timestimp, not a MySQL’s timestamp.

To get the current time as a timestamp you should use the following code:

current_time( ‘timestamp’ );

Related Posts:

  1. How to set a custom post type to have viewable future posts
  2. How to add multiple images to a custom post type single post?
  3. How to sort CPT by custom meta value (date), and return posts month by month
  4. Save metadata as a timestamp, display as a “pretty” date
  5. Display upcoming Events for next 7 Days
  6. Displaying a div from an assigned meta_value when on a page
  7. Retrieving meta-box from a custom-post-type
  8. Inefficient Query Confusion
  9. Filter posts of custom post type by meta key in (List All Section)
  10. WP_Meta_Query object with conditionals
  11. How to retrive Custom Post Type Meta Fields in Custom WP_Query
  12. Empty meta-box returns publishdate if no value is set?
  13. Custom Post Type ‘Event’: Chronological list of recurring events from meta_values in array
  14. Wp Meta Query does not work while simple Query Works
  15. Wp Query sort order from custom MetaBox
  16. Query events post type after current date and timezone
  17. Selecting posts older than the current Unix epoch timestamp
  18. Query Event Posts by Date
  19. How to query custom post then display sections by meta value
  20. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  21. Count of posts with meta_key filled in?
  22. Display all posts in a custom post type, grouped by a custom taxonomy
  23. WP_Query() show posts that end later than today
  24. How to check if a WP_Query has data
  25. Why won’t my metabox data save?
  26. Sorting a query by custom field date
  27. echo value from ‘select’ field type into page template using cmb2?
  28. Add metabox with media uploader in a custom post type [duplicate]
  29. Retrieving 3 latest post from each of 5 different custom post types
  30. Best way to arrange custom post types by Attributes -> Order metabox value?
  31. Wp-query causing problems with the_content();
  32. Multiple Archive Pages for Custom Post Types AND Taxonomies
  33. Exclude current post when getting related post on custom post type and taxonomy
  34. Display Posts of a Category in Alphabetical Order (Custom Post Type)
  35. Ordering Custom Post Types with WP_Query
  36. Filter posts with meta_query NOT IN where value has multiple values
  37. How to query different post types in specific order?
  38. How can I display my custom metaboxes on a custom post template?
  39. Unable to show meta box data in frontend
  40. is_main_query() not working for WP REST API
  41. Taxonomy Archive: Display only one post per term from separate custom taxonomy
  42. Loop through Custom Post Type, and then show children within each iteration
  43. Adding dropdown select meta box to custom post type – seems restAPI is interfering
  44. How to make sure content doesn’t display if selection is empty
  45. Archive for custom taxonomy lists all posts instead of current taxonomy
  46. Wp_query: sort by PHP variable
  47. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  48. Crafting WP_Query array, sort by date
  49. forming WP_Query for posts of all post types but from specific categories
  50. How can I get the number of custom post type posts that have a specific attachment image set?
  51. Including metaboxes from custom post types in global search — continued
  52. Custom Widget WP_Query problem
  53. Show Custom Post Type meta boxes only on Page Edit
  54. Adding Page Templates to post but it ignored it
  55. Parent Page and Breadcrumb URL’s for Custom Post Types Not Working
  56. Order posts by 2 custom fields and if one custom field is zero orderby another custom field
  57. Select event where start date is smaller than current date and end date is greater than current date
  58. Custom “radio button meta box” not saving correctly
  59. Meta Data for Custom Post Type not saving
  60. Remove “show sharing buttons” metabox Jetpack from custom post type
  61. Custon Content within WordPress Loop
  62. WP Query ‘posts_per_page’
  63. Custom Meta Box Causing Error: “Are you sure you want to do this? Please try again.”
  64. WP_Query order by two values
  65. How to Query in WordPress which shows Alphabetic Posts?
  66. Create query for both custom post type and category
  67. Meta box not appearing in my custom post type
  68. wp_dropdown_pages with tax_query clause
  69. Cache issue with WP_Query and custom field filtering
  70. Post Type => Any conundrum
  71. Custom Post Type Meta Box Text Input Field Won’t Save When Blank
  72. Creating an Events Feed with Sub Pages/Posts for Each Event
  73. custom taxonomy pagination 404 error
  74. wp_query can’t get max_num_pages in custom post type
  75. Custom Post Type meta data getting deleted on bulk editing taxonomies
  76. Custom Form / Search with Custom Post Type Data
  77. Query to show post current day
  78. Using ACF values in nested WP queries for CPT with date values in the past
  79. Show a custom post title in another custom post type in Meta box
  80. how to display posts content on the custom css popup by clicking on each title on the sidebar?
  81. Modify Publish Metabox location on CPT
  82. How do I insert a custom post type query after a certain number of recent posts and then resume recent posts?
  83. WP_Query for custom taxonomies showing posts from non-specified terms?
  84. how to display new private message to users?
  85. Make pagination work as a carousel (custom query)
  86. subtracting the current post form then whole loop, which is generating all CPT titles
  87. Custom taxonomy with custom post type archive page
  88. How to shows CPT which has specific meta key?
  89. Displaying WordPress posts from post and custom post type in custom taxonomy
  90. Metabox is not saving
  91. Loop carousel slider in wordpress
  92. Manually build WP_Query
  93. Loop with Custom Post Type and Taxonomies
  94. Select custom post by meta value
  95. 404 on Pages for Custom Post Type & Query_Posts
  96. Custom post type – permalink
  97. WP_Query arguments: Loop through custom post type – get all entries except excluded meta_key?
  98. How can I show posts with the same tag?
  99. Load posts via AJAX without draft status
  100. WP Query – Can’t get posts with specific taxonomy