Re: sort by date

Ok tested this and it won't work. Next question is sql question but anyway... Can I use STR_TO_DATE() or GET_FORMAT(DATE,'EUR') to query and sort dates to web page as a date even if the data is just a string in the db? Probably with GET_FORMAT(DATE,'EUR') it wont work cause it's a varchar field in the DB. Any idea how to put STR_TO_DATE() in to the following SQL query: SELECT event_id,name,date,time,place,type,info FROM test_table WHERE (group = '$group') AND (type = 'Game' OR type = 'training') ORDER BY date ASC Thanks a lot -Will "William Stokes" <kalles@operamail.com> kirjoitti viestissä:20050506054152.86469.qmail@lists.php.net... > 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