How to convert mysql var to date

Mysql var to date method: First use the str_to_date function to convert its varchar type to date type; then sort from small to large.

Recommended: "mysql video tutorial"

The following table:

First use the str_to_date function to convert its varchar type to date type, and then sort from small to large

Syntax: select str_to_date(class_time,'%Y%m%d %H: %i:%s') a from a order by a desc ;

## Let’s take a look at the date format of varchar type in Oracle Convert date type

SELECT to_char(to_date(m.ma_datetime,'yyyy-MM-dd hh24:mi:ss'),
 'yyyyMMdd') FROM my_task m;

The above is the detailed content of How to convert mysql var to date. For more information, please follow other related articles on the PHP Chinese website!