Mysql records are output in reverse order based on the date field, and mysql Date Field in reverse order
We know that inverted output is very simple.
Select * from table order by id desc
You can simply
Now the question is how to output the Date Field in reverse order.
Here we use cast () to convert the specified field to the type we need
The following are SQL statements in the actual project:
Select * from water where phoneNumber = @ phoneNumber order by cast (date as datetime) desc
Let's think about deep content, instead of thinking about it.
There are two ways to convert the data type after reading the data.
1. cast () method
2. convert () method
Format
1. cast (field name as data type)
For example, the preceding SQL statement
Cast (date as datetime)
2. convert (field name, data type)
Example: convert (da, datetime)
The above is a summary of mysql records output in descending order based on the date field. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!