US to UK db DATE functions

[bushkid85]

I know of a few functions that can retrieve the date from my phpmyadmin US formatted date to UK d-m-y but for the life of me I cannot get any of them to work.

Any help would be greatful. Even an example code, only need three col to retrieve too - pain in backside.

Thank you in advance.

[bushkid85]

I found the way…myself as usual.

If anyone else needs to know then here it is

example:

"SELECT col1, col2, DATE_FORMAT(date, '%m/%d/%Y') FROM table"; 

Easy as pie in the end.

[bushkid85]

DATE_FORMAT(date, ‘%d/%m/%Y’)

^^ is UK obviously.