Re: sort by date

Thanks Richard. That did the trick. Now to the DB fixing business... -Will "Richard Lynch" <ceo@l-i-e.com> kirjoitti viestissä:3955.24.136.1.28.1115610399.squirrel@www.l-i-e.com... > 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