Date Query to Pull Current and Future Posts

I wonder if you mean this kind of date_query:

$query->set( 'date_query', [
    [
        'after'     => 'today midnight',
        'column'    => 'post_date_gmt',
        'inclusive' => true,
    ],
] );

where we use the after attribute.

Here the after date will be calculated by WP_Date_Query as:

gmdate( 'Y-m-d H:i:s', strtotime( 'today midnight', current_time( 'timestamp' ) ) );

With the column set as post_date_gmt, it generates to the following SQL condition:

wp_posts.post_date_gmt >= '2015-04-06 00:00:00'

on 6th of April 2015.

Update – Some Tests:

I ran some tests, trying to understand better the string datetime generation of WP_Date_Query:

wpse_test( 
    time(), 
    'GMT', 
    'today',
    'Y-m-d H:i:s',
    '#1 Using time() for blog with UTC-7 and PHP timezone as GMT'
);
wpse_test( 
    time(), 
    'US/Pacific', 
    'today',
    'Y-m-d H:i:s',
    '#2 Using time() for blog with UTC-7 and PHP timezone as US/Pacific'
);
wpse_test( 
    current_time( 'timestamp' ) , 
    'GMT', 
    'today',
    'Y-m-d H:i:s',
    '#3 Using current_time() for blog with UTC-7 and PHP timezone as GMT'
);
wpse_test( 
    current_time( 'timestamp' ) , 
    'US/Pacific', 
    'today',
    'Y-m-d H:i:s',
    '#4 Using current_time() for blog with UTC-7 and PHP timezone as US/Pacific'
);

where:

/**
 * Test the string datetime generation in WP_Date_Query 
 * with a given timezone and current time
 */

function wpse_test( $time, $timezone, $timestring, $format, $title )
{
    date_default_timezone_set( $timezone );

    printf( '--- %s ---', $title );
    echo PHP_EOL;
    echo date_default_timezone_get();
    echo PHP_EOL;
    echo $time;
    echo PHP_EOL;
    echo date( $format, $time );
    echo PHP_EOL;
    echo gmdate( $format, $time );
    echo PHP_EOL;
    echo date( $format, strtotime( $timestring, $time ) );
    echo PHP_EOL;
    echo gmdate( $format, strtotime( $timestring, $time ) );
    echo PHP_EOL;
}

The result is the following output:

--- #1 Using time() for blog with UTC-7 and PHP timezone as GMT ---
GMT
1428412051
2015-04-07 13:07:31
2015-04-07 13:07:31
2015-04-07 00:00:00
2015-04-07 00:00:00
--- #2 Using time() for blog with UTC-7 and PHP timezone as US/Pacific ---
US/Pacific
1428412051
2015-04-07 06:07:31
2015-04-07 13:07:31
2015-04-07 00:00:00
2015-04-07 07:00:00
--- #3 Using current_time() for blog with UTC-7 and PHP timezone as GMT ---
GMT
1428386851
2015-04-07 06:07:31
2015-04-07 06:07:31
2015-04-07 00:00:00
2015-04-07 00:00:00
--- #4 Using current_time() for blog with UTC-7 and PHP timezone as US/Pacific ---
US/Pacific
1428386851
2015-04-06 23:07:31
2015-04-07 06:07:31
2015-04-06 00:00:00
2015-04-06 07:00:00

We can see that time() doesn’t change with the timezone and is in GMT.

So it seems that we have to be carefule regarding the timezones!

Related Posts:

  1. Why the ‘date_query’ is not working in ‘pre_get_posts’ hook?
  2. Sticky Posts exceed posts per page limit
  3. Theres a way to use $query->set(‘tax_query’ in pre_get_posts filter?
  4. Modify Taxonomy pages to exclude items in child taxonomies
  5. Obliterate the main query and replace it
  6. Post injection – how to exclude the original post
  7. Adding meta_key via pre_get_posts causes navigation to disappear
  8. Sorting posts that has a meta value first then the rest of the posts
  9. pre_get_posts on a page
  10. How pre_get_posts filter by roles in WP Admin
  11. Weird problem with pre_get_posts and $query->is_page()
  12. Why is ‘pre_get_posts’ having no effect?
  13. pre_get_posts all posts and custom post type with certain tag
  14. Using Sessions to Filter Posts – bad thing?
  15. pre_get_posts and the blog page
  16. Archive by custom post type and custom date field
  17. pre_get_post filter returns results when there should not be
  18. Trying to exclude first 5 posts from the first page on the homepage
  19. Exclude a WordPress post from pre_get_posts if a field is null
  20. Only show certain post types in recent posts widget
  21. pre_get_posts for exclude category
  22. pre_get_posts: using tax_query only for certain post type
  23. pre_get_posts dont firing… Anybody knows whats the wrong with my code?
  24. Restrict Search Query To After Specific Date
  25. WP_Error not displaying errors
  26. Show all posts even if URL points to a single one
  27. How to achieve post_status__not_in?
  28. Ordering by meta_key
  29. Using a pre_get_posts filter to search for multiple strings on all meta values
  30. Removing taxonomy query by pre_get_posts
  31. Using different parameters for different queries with pre get posts in functions.php
  32. how to restrict posts_request filter to the main query only
  33. Automatically applying a pre_get_posts filter for child categories only
  34. How to override a query and display specific page by ID?
  35. pre_get_posts variables
  36. Another query in pre_get_post cause memory issue
  37. pre_get_posts having no effect on my category archive
  38. pre_get_posts returns non property object when using posts__not_in
  39. Override tax_query with pre_get_posts to include other term_ids on a single category
  40. date_query in pre_get_posts out of memory
  41. $query->is_main_query() is causing query’s tax_query to be ignored
  42. Menu disappears when meta_key changed [closed]
  43. pre_get_posts with multiple queries
  44. How to show the last and newest modified post in a custom category?
  45. Altering the main query using get_post_meta() in pre_get_posts
  46. Why query by specific date with variables doesn’t return same result that with harcoded integers?
  47. Sort WordPress Archive by multiple oderby arguments in pre_get_posts action
  48. Exclude post type with pre_get_posts?
  49. Exclude page by title for non admins
  50. problem with setting tax_query in pre_get_posts
  51. Problem ID to exclude specific posts from category
  52. Modify Taxonomy pages to exclude items in child taxonomies
  53. Modify author archive query to combine two queries
  54. Change post order on archive to be displayed by most commented being ignored by theme
  55. Complex query using pre_get_posts
  56. Super confusing ‘pre_get_posts’ behavior with $query->set
  57. Having trouble with settings terms as array in pre_get_posts
  58. Override main query for page template
  59. Querying custom taxonomy on category-specific page is overwritten by function
  60. how to get content from other site and show it?
  61. Insert a variable in pre_get_posts
  62. Extend taxonomy term page with other posts
  63. Set a custom number of posts on the first page
  64. Why does this query not SELECT post IDs like a normal query would?
  65. Please ensure me that I’m not crazy using the pre_get_posts [closed]
  66. How to pass >= condition filter to my year custom tax_query
  67. What is the proper way to use pre_get_post?
  68. pre_get_posts has php notice when not on CPT archive
  69. Duplicating event posts in wordpress
  70. WP_Query orderby post__in remains ineffective in the Loop [closed]
  71. Custom search filter causes menu and query_posts problems
  72. Show only posts which can be commented OR have custom meta field
  73. How to show more posts on an archive page?
  74. Include post id[s] into WP_Query()
  75. Pre get posts for single post
  76. Most viewed post for the last 2 days using WP_Query
  77. SQL Statement generated by WP_Query not producing expected results
  78. Conditional tag for all categories of a custom post type
  79. filter search result with custom post type meta key
  80. Using meta_query and custom fields within pre_get_posts to return posts within a numerical range
  81. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  82. How to set back query var author_name after unset it?
  83. Store sticky post’s ids in a transient
  84. Date_query problems
  85. Using meta_query with multiple keys and compare values
  86. Can I set my WP_Query to be a Main Query?
  87. Exclude post by custom meta with pre_get_posts
  88. How to exclude pages from WP search based on page title
  89. Main menu not appearing in custom post type archive
  90. cannot filter after using pre_get_posts
  91. queried_object using pre_get_posts gets notices and warning
  92. WP_Query, Paginate by Custom Field
  93. Exclude taxonomy Query if post_type
  94. Block internal search queries with pre_get_posts and regex rules
  95. Query to Exclude Child Pages from Custom Post Type Archive
  96. How do I troubleshoot pre_get_posts with Debug Bar?
  97. Sort posts in dashboard using custom field; also include posts where field isn’t set
  98. Run search query again without pagination gives no results?
  99. How do I sort post listing by child post count?
  100. Get query result before posts are displayed?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)