GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Varius · 03-23-2007, 10:13 AM

Try something like this (I'm not awake yet so might have a typo in there heh)

UPDATE b1datefix SET date2 = CONCAT(SUBSTRING(date,-4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date,FROM -7 FOR 2));

Enjoy

03-23-2007, 10:13 AM
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	Try something like this (I'm not awake yet so might have a typo in there heh) UPDATE b1datefix SET date2 = CONCAT(SUBSTRING(date,-4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date,FROM -7 FOR 2)); Enjoy __________________ Skype variuscr - Email varius AT gmail