date

[plisken]

Hi. I have a char field in my mySql database that contains a date in this format 20021203. (I don't have priviliges to change it to a date field) Is there a way I can change the format of the date in my select statement? This is the format I need: 03.12.2002
I could make a function that would change it after I get it back from the database, but I was hoping there was a way to do it in the query?

[Wien]

i strongly recommend you do format your string in PHP but if you really want to do it with mysql functions try this :

SELECT concat(substring(DateField,7,2),'.',substring(DateField,5,2),'.',substring(DateField,1,4)) .... FROM

anyway don't forget to use Date type in you database, it's really worthy