Get today's posts

Here are a couple of ways you can write that SQL. If you can, you should write them as plain SQL, it's faster.

PHP Code:

ok thanks @jreklund let me try 


---

Here are a couple of ways you can write that SQL. If you can, you should write them as plain SQL, it's faster.

public function today_post(){
    $datebytimezone = new DateTime("now", new DateTimeZone('UTC'));
    $date = $datebytimezone->format('Y-m-d');
    $query = $this->db->get_where('post',
        array(
            'posted_at >=' => "{$date} 00:00:00",
            'post_closed' => 0
        )
    );
    return $query->num_rows();
}

This one works the others are have CURDATE() in which i get an error like curdate() not recofnized as an intenally or inbuld function.
Thank you so much @jreklund as always, you a legend.