"Markus Ernst" <derernst@NO#SP#AMgmx.ch> writes:
"Michael Fuhr" <mf***@fuhr.org> schrieb im Newsbeitrag
news:3f********@omega.dimensional.com...
Is there a reason you can't have MySQL format the date the way you
want it with DATE_FORMAT()?
If you want to order by the date you can't do that.
If you want to sort by date in PHP then changing the date format
can make the sorting awkward, but using ORDER BY in the query works
just fine:
mysql> -- Unordered query
mysql> select name, date_format(birthday, '%d-%b-%Y') from people;
+---------+-----------------------------------+
| name | date_format(birthday, '%d-%b-%Y') |
+---------+-----------------------------------+
| Matthew | 20-Nov-1997 |
| David | 06-Jul-1993 |
| Scott | 17-Feb-1992 |
| John | 03-Nov-1997 |
| Susan | 05-Apr-2001 |
| George | 13-Aug-2000 |
| Henry | 09-Jul-1991 |
| Mary | 16-Jul-2000 |
| Thomas | 14-May-1992 |
| Robert | 20-Mar-1994 |
+---------+-----------------------------------+
10 rows in set (0.00 sec)
mysql> -- Ordered query
mysql> select name, date_format(birthday, '%d-%b-%Y') from people order by birthday;
+---------+-----------------------------------+
| name | date_format(birthday, '%d-%b-%Y') |
+---------+-----------------------------------+
| Henry | 09-Jul-1991 |
| Scott | 17-Feb-1992 |
| Thomas | 14-May-1992 |
| David | 06-Jul-1993 |
| Robert | 20-Mar-1994 |
| John | 03-Nov-1997 |
| Matthew | 20-Nov-1997 |
| Mary | 16-Jul-2000 |
| George | 13-Aug-2000 |
| Susan | 05-Apr-2001 |
+---------+-----------------------------------+
10 rows in set (0.01 sec)
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/