Quote:
Originally Posted by BradM
MySQL 4.0.26-standard
That's probably why there is a problem. :/
|
I don't have any version 4.x around anymore so can't help you much there...I would say move to 5.1 the are a LOT of new features to like plus upgrading is like a 5-10 minute job if you know how to do it.
Otherwise, yeah you are probably stuck doing it on the php end.
Last try that might work for you since the middle one did work form your output:
CONCAT(SUBSTRING(date,7,4),'-',SUBSTRING(date,1,2),'-',SUBSTRING(date,4,2))