When I write a MySQL query and have a where clause like such.
SELECT *
FROM my_table
WHERE date_field > 0
It works just fine.
However when I try and translate that in to my Laravel
$query = $this->getQB();
$query->where('date_field', '>', 0);
$return = $query->get($cols);
I get an empty result set. I figured out I can change my where clause to say
$query->where('date_field', '!=', '0000-00-00 00:00:00');
and everything runs fine.
My question is: Why can't I do the greater than zero on a date field?