jeudi 13 août 2015

subtract 1 month from a DB column symfony2

I am trying to write a query in order to get all the data whose date is greater than 11 months and less than 12 month. I have tried the query below which returns date difference in days. Is there any way I can check on months ??

$qb ->select("pj,DATE_DIFF(CURRENT_TIME(), pj.date) as dt)
    ->from("PrevJbs", "pj");



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire