"Markus Ernst" <derernst@NO#SP #AMgmx.ch> writes:
"Michael Fuhr" <mf***@fuhr.org > schrieb im Newsbeitrag
news:3f******** @omega.dimensio nal.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(bir thday, '%d-%b-%Y') from people;
+---------+-----------------------------------+
| name | date_format(bir thday, '%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(bir thday, '%d-%b-%Y') from people order by birthday;
+---------+-----------------------------------+
| name | date_format(bir thday, '%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/