Posted By

olive on 02/01/07


Tagged

date


Versions (?)

Date au format XL


 / Published in: SQL
 

  1. CONCAT(SUBSTRING(date,7,2), '/', SUBSTRING(date,5,2),'/',SUBSTRING(date,1,4)) AS DATE
  2. 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

Report this snippet  

You need to login to post a comment.