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