How to use the MySql 's methods DATE_ADD,DATE_FORMAT in Zend Framework2

Question

I have a sql query string to my database

I hope this mysql sql can find the database row create time plus one day less time now

sql ='SELECT * FROM `order` WHERE (DATE_ADD(DATE_FORMAT(`create_date`, '%Y-%m-%e %H:%i:%s'), INTERVAL 24 HOUR) <= now()) 

i know zf1 code

zf1

function test(){
   $select = $this->select(true)->setIntegrityCheck(false);
   $select->where("DATE_ADD(DATE_FORMAT(`om_created`, '%Y-%m-%e %H:%i:%s'), INTERVAL 24 HOUR)  <= now()));
   $data = $this->fetchAll($select);
}

Answer 1

Try this:

SELECT * FROM `order` WHERE DATE_ADD(create_date, INTERVAL 24 HOUR) <= NOW()

OR

SELECT * FROM `order` WHERE DATE_ADD(create_date, INTERVAL 1 DAY) <= NOW()

Answer 2

you can use something like:

select * from table where date >= DATE_SUB(NOW(), INTERVAL 1 month)

In ZF1 you can write something like:

$select->from('tablename')
 ->where( 'date >=  DATE_SUB(NOW(), INTERVAL 1 month)');