'if datetime in mysql database is saved in the format of yyyyMMdd, is it possible to sort the date string of yyyyMMdd in ascending or descending order?
Printable View
'if datetime in mysql database is saved in the format of yyyyMMdd, is it possible to sort the date string of yyyyMMdd in ascending or descending order?
Yes. But why store it as a string when a type is available for date and time?
Datetime data type - http://www.sqlmag.com/Articles/Artic...3488.html?Ad=1