 |
 |
Find a programming school near you
php-general | 2005051
Date: 05/08/05
- Next message: Richard Lynch: "Re: [PHP] Sending htm as it's being generated"
- Previous message: Richard Lynch: "Re: [PHP] compiling dynamic extensions without root access"
- In reply to: William Stokes: "[PHP] sort by date"
- Next in thread: William Stokes: "Re: [PHP] sort by date"
- Reply: William Stokes: "Re: [PHP] sort by date"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, May 5, 2005 10:42 pm, William Stokes said:
> 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?
As noted, your best solution is to fix the database.
A short-term hack would be to:
order by substring(your_field, 6, 4), substring(your_Field, 3, 2),
substring(your_field, 1, 2)
Read the MySQL manual to check the actual numbers for substring in MySQL
-- Like Music? http://l-i-e.com/artists.htm-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
- Next message: Richard Lynch: "Re: [PHP] Sending htm as it's being generated"
- Previous message: Richard Lynch: "Re: [PHP] compiling dynamic extensions without root access"
- In reply to: William Stokes: "[PHP] sort by date"
- Next in thread: William Stokes: "Re: [PHP] sort by date"
- Reply: William Stokes: "Re: [PHP] sort by date"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
