erme Posted February 22, 2010 Share Posted February 22, 2010 Hi I am trying to write something like this: SELECT * FROM $Table ORDER BY cast(Expiry as DateTime) DESC Expiry being a date format such as 10/02/2010 Link to comment https://forums.phpfreaks.com/topic/192956-cast-as-datetime/ Share on other sites More sharing options...
erme Posted February 23, 2010 Author Share Posted February 23, 2010 Or is this not the correct way to order by a date so that the date is order .. closet first? Link to comment https://forums.phpfreaks.com/topic/192956-cast-as-datetime/#findComment-1016729 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.