converting a date

[kante]

when i make a query to mysql dtbase in a datetime field it returns me a result with a date in the US format.

is there a php function that gets a datetime string and converts it in another language format?

(e.g. yyyy-mm-dd hh:mm:ss ---> dd-mm-yyyy hh:mm:ss)

thank you

[cahva]

Yes there is, but you dont have to format it in PHP. You can format it straight in your SELECT statement.
example:
SELECT DATE_FORMAT(datefield, '%d-%m-%Y %H:%i:%s') as date FROM table

If you want to know more about mySQL's date and time functions, check here.