Anonymous
public php v1 · immutable $dateSql="SELECT DATE_FORMAT(Date, %d, %m, %Y) FROM PurchaseOrders WHERE purchase_id='$id'"; $data=$db-->query($dateSql); $datesql=$data->getOne(DB_FETCHMODE_ASSOC); $datesql=explode('-',$datesql); $Date=$datesql[2] . "/" . $datesql[1] . "/" . $datesql[0];