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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.