Selecting posts older than the current Unix epoch timestamp

Question

I am trying to perform the following query, which originates by the fact the post's 'date' and 'time' are entered as separate custom fields.

$args = array(
      'post_type' => 'some_kind_of_posts',
      'posts_per_page' => 3,
      'orderby' => 'meta_value_num',
      'meta_key' => strtotime('date'. ' ' .'time'),
      'order' => 'DESC',
      'meta_query' => array(
           array(
                'key' => strtotime('date'. ' ' .'time'),
                'value' => strtotime(date('H:i',time() + 3600*2))
                'compare' => '<',
                ),
      ),
);
$query = new WP_Query( $args );

In other words, I need to first combine 'date' and 'time', in order to select posts which are older than the current time. The latter is converted into Unix epoch timestamp (is this a good option ?).

I have elsewhere checked strtotime(get_field('date'). ' ' .get_field('time')) and strtotime(date('H:i',time() + 3600*2)) by echoing them, and obtained the expected Unix epoch time in seconds.

However, key-value comparison fails: I do not manage to select posts which are older than current time.

Many thanks for any hint on how to tackle the problem.

Answer 1

This piece of code should solve your problem:

function filter_where($where = '') {
    $where .= " AND post_date < '" . date('Y-m-d') . "'";
    return $where;
}

add_filter('posts_where', 'filter_where');
$query = new WP_Query(array('posts_per_page' => 3));
remove_filter('posts_where', 'filter_where');

Answer 2

you are trying to compare the combined date and time custom fields with the current time to filter out posts that are older than the current time.

Replace combined_date_time with the actual meta key name where you store the combined 'date' and 'time'.

Use current_time('timestamp') to get the current time in Unix timestamp format.

Add 'type' => 'NUMERIC' to the meta query to ensure proper numeric comparison

$args = array(
    'post_type'      => 'some_kind_of_posts',
    'posts_per_page' => 3,
    'orderby'        => 'meta_value_num',
    'meta_key'       => 'combined_date_time', // Replace 'combined_date_time' with the actual meta key name
    'order'          => 'DESC',
    'meta_query'     => array(
        array(
            'key'     => 'combined_date_time', // Replace 'combined_date_time' with the actual meta key name
            'value'   => current_time('timestamp'), // Get the current time in Unix timestamp
            'compare' => '<',
            'type'    => 'NUMERIC' // Specify the type as numeric for proper comparison
        ),
    ),
);
$query = new WP_Query($args);