Mysql records output _mysql According to the date field in reverse

We know that the reverse output is very simple.

SELECT * FROM table ORDER BY id DESC

Just so you can.

So now the question is how the date field is going to reverse the output

Here we use CAST () to convert the specified field to the type we need

The following are the SQL statements in the actual project

SELECT * from water where phonenumber= @phoneNumber order by cast (date as DateTime) desc

We talk about learning without thinking, and we think about the deeper content.

There are two ways to know the type of conversion through the reference data

1.cast () method

2.convert () method

Use format

1.cast (field name as data type)

such as the above SQL statement

Cast (date as DateTime)

2.convert (field name, data type)

Example: Convert (da,datetime)

The above is a small series to introduce the MySQL record according to the date field reverse output, hope to help everyone, if you have any questions please give me a message, small set will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!