timestamp and data output format

[Anon]

Hi,

I have a MySQL table with a Timestamp(8) field.

I would like to get out data form this field and format it as dd-mm-yyyy istead of yyyymmdd .

This field is selfcompiled each time a new record is inserted, so I have no control of the date format.

How can I re-format the output date ?

Thank you

[origo]

See the DATE_FORMAT documentation at http://www.mysql.com/doc/D/a/Date_and_time_functions.html

[fabiuz]

thank you for the answer, I have read such documentation, but it seems like it doesn't work for TIMESTAMP fields but only for DATE fields.

Other ideas ?

Thanks