Mysql records are output in reverse order based on the date field, and mysql Date Field in reverse order

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!