How to check if a table date is lower than today in Doctrine - Postgresql

Question

I have to check if the user has registered an expiration date, if yes, I check if that date is lower than today if it is, it shows if it does not hide, I did so:

        $this->noticia = Doctrine::getTable('Noticias')->createQuery('s')
            ->select('s.*')
                    ->where("situacao = ?", 'ativo')
                    ->where("data_validade < ", 'date("Y-m-d")') 
              // tentei dessa maneira tambem
              // criei uma variavel la em cima no escopo ++ $data = date("Y-m-d");
             // e chamei ela assim(embaixo) 
             // ->where("data_validade < ") . $data
            ->orderBy('data_cadastro desc')
            //->limit(5) // temp
            ->execute();

but in the browser, the page is all blank and no error appears. hmm. What can be ?

Answer 1

I will assume that you are passing the current date through the parameter $date, which is a \DateTime. Your query would look like this:

$this->noticia = Doctrine::getTable('Noticias')->createQuery('s')
    ->select('s.*')
    ->where("situacao = 'ativo'")
    ->where('data_validade < :data')
    ->orderBy('data_cadastro desc')
    ->setParameter('data', $data->format('Y-m-d H:i:s'))
    ->execute();