sort by date
| From: | William Stokes | Date: | Fri, 06 May 2005 05:42:24 +0000 |
| Subject: | sort by date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-214593@lists.php.net to get a copy of this message | ||
Hello,
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read the DB is it still possible to sort the data by
date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
date information to be stored as a date in the DB? Will it work or is the
output going to be sorted randomly?
Thanks
-Will