meta_query date and time comparisons

You are mixing up an older meta syntax with the newer one. I’d suggest you clean that up for readability and for potential compatibility in the future. (WordPress does seem to parse the mixed query correctly though)

$args = array(
  'posts_per_page'    => -1,
  'post_type'         => MDJM_EVENT_POSTS,
  'post_status'       => 'mdjm-approved',
  'meta_query'        => array(
    'relation'  => 'AND',
    array(
        'key'       => '_mdjm_event_date',
        'value'     => date( 'H:i:s' ),
        'compare'   => '<=',
    ),
    array(
        'key'       => '_mdjm_event_finish',
        'value'     => date( 'H:i:s' ),
        'compare'   => '>'
    ),
  ),
);

The one other thing I changed was the type casting to numeric of the date value. I am pretty sure that was tripping up your query. If you run SELECT CAST('23:20:36' as signed) in a MySQL console (PHPAdmin, command line, etc) you will see that what gets returned in just “23”. That isn’t going to match.

Related Posts:

  1. How do you get posts by meta_query using the JSON API plugin?
  2. Meta query: get posts with value in a multidimensional array
  3. Get all posts with a certain meta key, except for one with specific title
  4. Using get_posts, I need to use a combination of OR & AND relations
  5. setup_postdata() does not seem to be working?
  6. Regenerate Slugs From Title of Posts
  7. get_posts – get all posts by author id
  8. WordPress get_posts by category
  9. Alternative to get_posts() due to multithreading cache crash
  10. Sort “get_pages” by menu order not ordering
  11. get posts based on meta value of the author
  12. date_query not returning some posts in date range
  13. Get the exact SQL query that get_posts() generated
  14. Query posts ordering by title, but ignore ” and special characters
  15. get_posts inside cron
  16. Meta Query with date and time on the same Day before given time
  17. get_posts returning empty array
  18. get_posts only children from certain parents
  19. Problem with get_posts, tax_query and counting the number of posts
  20. Loop through two different sets of custom fields
  21. Filtering custom post type query
  22. data returned from get_post($postId) have different keys than wp-json/wp/v2/posts/{postId}
  23. get_posts from post x(offset=>x) to end
  24. With get_posts(), how can I put a category as a variable
  25. Serialized array, grab specific posts with meta_key/meta_value[0]->is_featured
  26. How do I combine these 2 queries
  27. Increase the page size of the WordPress REST API
  28. How to generate a list of posts published on current day?
  29. Cache Get_posts
  30. get_posts() returns all posts rather than the ones specified with ‘post_author’ =>
  31. Query random post from different categories
  32. get_posts() excluding all children of a specific post/page
  33. If clauses in get_posts query
  34. `get_posts()` ignore my custom post
  35. excluding current post from get_posts
  36. How to query posts to include specific pages of one post type, and all pages of another post type?
  37. Only retrieve posts where post_excerpt has been filled out
  38. Can I use numberposts=-1 and offset together when using get_posts()?
  39. Ordering posts in get_posts
  40. Get posts inside Get terms problem
  41. Ho to add get_relative_date and post_except to this get_latest_post query?
  42. Get posts with multiple meta values
  43. Meta Query returns wrong number of posts
  44. Only showing the_date and the_excerpt for first entry in get_posts
  45. get_posts() not working in functions.php
  46. Getting only a specific post type with get_post?
  47. Display post details by post ID
  48. What is the p parameter in a get_posts() parameter array?
  49. Exclude post format from get_posts
  50. Memory issue with get_posts( ) function
  51. get_posts() using an array of post ids [closed]
  52. Delist entries in the_loop
  53. How can I show the author’s latest post with title?
  54. Unique Problem with the php date and get_posts
  55. get the post_date of ID
  56. Get posts in between specific ID’s
  57. Don’t submit post if post title exists
  58. Why would get_posts be ignoring posts with 2-digit ids?
  59. Not able to get random post
  60. Order custom post type by custom field (created by PODS) via PHP
  61. get_posts( $args ) return empty data
  62. Override Blog pages show at most with get_posts
  63. SQL query generated by WP_Query is not the same what request echoes
  64. ‘child_of’ in get_posts not working
  65. Fetching All Posts (200+) in a Category – Performance Issues?
  66. Can’t get Category link inside get_posts
  67. How do I get only a certain number of images from a post (minus the featured image)?
  68. Sort get_children by menu_order
  69. Working with get_posts parameters/arrays/strings
  70. Getting post by specific date in Advance Custom Field
  71. Select objects from get_posts()
  72. Divide the list into two columns (get_posts)
  73. Using post title as term in query, only working with single word titles
  74. Single random post in homepage
  75. WordPress echoing content in seemingly random place
  76. How to use get_posts to filter against a single post id?
  77. get_posts query is taking about 40 seconds to execute
  78. Why set cookie from URL parameter doesnt work all the time?
  79. get_posts filter meta_query using ACF Checkbox
  80. How to get a custom post with the largest ID (not the last post by date)
  81. How to mark only one post as Featured post?
  82. Is there a way to extract a single post better than using get_posts()?
  83. Array merging multiple get_posts throwing Undefined offset error
  84. Custom Category widget
  85. Get Posts from Custom Meta Query
  86. Zero posts returned with get_posts() on edit.php, but posts are returned on post.php
  87. Better way to query posts?
  88. How to exclude posts with empty and non-existent relational custom field with meta_query?
  89. Use not custom fields in get_posts() meta_query?
  90. get_posts array ‘between’ not behaving
  91. How To Use get_posts & get_the_post_thumbnail Outside The Loop
  92. WordPress – List Sub Categories and Sub-Sub Categories, With Posts
  93. get_posts() and ‘posts_per_page’ arg
  94. Show posts in a list separated by day
  95. Sorting posts by specific order
  96. Sorting not working with get_posts
  97. Display all Post titles with Category and Tag
  98. Intergrate WP into website
  99. Latest post on specific category and custom css
  100. Display post’s description and caption