Formatting Date from MySQL

[gmail2]

Is there any easy way of formatting a date pulled from mysql without having to take the string apart? The php date() function only works with integers, not actual dates as far as I can see. I don't mind storing the date as an integer instead, however the system I'm working on also needs to have the ability to upload .csv files into a table which has dates. How can I convert them from UK date format to either integer or MySQL date format?

Thanks in advance for any help

 

[Vragabond]

MySQL has a great function called DATE_FORMAT which should suit all of your needs.