Ninjakreborn Posted May 14, 2010 Share Posted May 14, 2010 I have dates in the DB set as varchar (not datetime) and the format '5/13/2009'. So I want to get results from the database that are sorted by this date...the newest ones would show first. I have tried an order by on the "news_date" field which is the date column but it makes no difference. Any advice? Link to comment https://forums.phpfreaks.com/topic/201751-dates/ Share on other sites More sharing options...
trq Posted May 14, 2010 Share Posted May 14, 2010 Change your database field to a proper data type for the data it is representing. Link to comment https://forums.phpfreaks.com/topic/201751-dates/#findComment-1058564 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.