如何修改此查询，以便开始/结束日期按天而不是确切时间？

Question

I'm using the query below to get posts based on the start and end dates which use the UNIX timestamp.

Currently, it's only returning results if the start time occurred after today's time. For example, if it's 5:00 PM and the start date is 6:00 PM, it won't pick it up. I would like it to consider anytime during today (from midnight last night to midnight tonight) as being the start date.

Can someone tell me how to update my code to get this to work?

$current_time is equal to 1305132894, which is 5:54 EST today.

'meta_query'        => array(
    array(
        'key'       => 'start_date',
        'value'     => $current_time,
        'compare'   => '<'
    ),
    array(
        'key'       => 'end_date',
        'value'     => $current_time,
        'compare'   => '>'
    )
)

Answer 1

If you only need it to work for today, you can use:

$minDate = strtotime('midnight today');
$maxDate = strtotime('midnight tomorrow -1 second');

or alternatively

$minDate = mktime(0,0,0);
$maxDate = mktime(11,59,59);

Some combination of mktime() and strtotime() should work.