I have a datetime field in a mysql database. By default it is formatted as Y-m-d H:i:s.

When I query the database for the date, I would like to reformat it before displaying it in the browser. I would like to write it like:

This page was last updated at H:i on d-m-Y

How can I do this please?

Thank you!