Posted by William Stokes on 10/19/08 11:15

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

[Back to original message]