[SOLVED] Problem with today selector???

[PWaddict]

Using the following selector I should be able to get today's and past posts but I'm only getting the past ones.

$news_posts = $page->children("limit=10, news_date<=today");

If I change the operator to >= then I get today's and upcoming posts but why the <= doesn't display today's posts too?

[PWaddict]

Using this it properly works:

$today = time();
$news_posts = $page->children("limit=10, news_date<=$today");

 

[BitPoet]

In the database, datetime fields have a time part that is set to the current time when saving a new value for a date only field. "today" is interpolated by PHP's strtotime function to 00:00:00 of today's date, so <= will only match articles posted exactly at midnight. You probably want to use

$news_posts = $page->children("limit=10, news_date<tomorrow");

instead.