July 9th, 2013, 07:54 PM
A Change of Season
Convert data stored as strtotime('now') to date format inside Mysql.
I have stored date in database as strtotime('now')
. I use the query in a few websites. I wonder if it's possible to convert that to date('d/m/Y') INSIDE MySql (not with Php).
function list_leads($where=" ", $sort='enquiries.id DESC')
$sql = '
enquiries.status as S,
LEFT OUTER JOIN agents ON agents.id = enquiries.agent
LEFT OUTER JOIN lead_status ON lead_status.id = enquiries.status
ORDER BY '.$sort.'
$query = $this->db->query($sql);
Last edited by zxcvbnm : July 9th, 2013 at 08:08 PM.