Return to Snippet

Revision: 2310
at February 1, 2007 07:14 by olive


Initial Code
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

Initial URL

                                

Initial Description

                                

Initial Title
Date au format XL

Initial Tags
date

Initial Language
SQL