How change the data format from mysql?

[Anon]

Someone know if is possible take the data from mysql db, if is formatted 2001-06-10 then i want change to 10-6-2001.

in mysql is Ymd then i want show in page like dmY

Thanks until now!!!

Julio Gonçalves

[yelvington]

There are many ways. Here is one.

http://www.php.net/manual/en/function.sscanf.php

http://www.php.net/manual/en/function.sprintf.php