/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
CONCAT(SUBSTRING(DATE,7,2), '/', SUBSTRING(DATE,5,2),'/',SUBSTRING(DATE,1,4)) AS DATE CONCAT(SUBSTRING(c.date,7,2), '/',SUBSTRING(c.date,5,2),'/',SUBSTRING(c.date,1,4),' ',SUBSTRING(c.date,9,2),':'SUBSTRING(c.date,11,2),':'SUBSTRING(c.date,13,2)) AS DATE