make date return mm-dd-yyyy

[kappaluppa]

How do I set the date field in mySQL to return the date field in the mm-dd-yyyy format, rather than yyyy-mm-dd.

thanks!!!

[grimz]

What I do is set it to an INT and store time() in it then use data() when im displaying it...

[mithril]

You need to either use some of the MySQL date functions to format the date during the query, or use PHP's date functions to format the data returned by the query. The first method is preferable as it's what a database is designed to do.

For example, the following query should return your date properly where "date" is the name of the field storing the date info:

    SELECT DATE_FORMAT(date, '%m-%e-%Y') FROM my_table;

-geoff