How to change mysql date format

sidboyce · 10-24-2007, 06:52 AM

My dates in mysql are the ISO standard 2007-10-24 in queries and I would like to change to 24-10-2007 format.
Help appreciated, search didn't throw up anything useful.

tronayne · 10-24-2007, 07:25 AM

You may want to take a look at http://dev.mysql.com/doc/refman/5.0/...-overview.html and http://dev.mysql.com/doc/refman/5.0/en/datetime.html. At the bottom of the first reference is an example:

Quote:

To extract a timestamp in a human-readable format, use:

SELECT DATE_FORMAT(timestamp,'%l:%i:%s %p on %M %D, %Y') as ...
FROM ...

This returns:
9:15:37 PM on April 22nd, 2005

You can change the formatting or ordering in the single quotes as necessary. A complete list of the specifiers (like '%Y') are listed if you look up DATE_FORMAT.

Information about the DATE_FORMAT function is found at http://dev.mysql.com/doc/refman/5.0/...on_date-format

Hope this helps some.