Posted by Richard Lynch on 05/09/05 06:46

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

[Back to original message]