How to convert the varchar type into the date type in MySQL, varchardate

How to convert the varchar type into the date type in MySQL, varchardate

See the following table:

Use the str_to_date function to convert the varchar type to the date type, and then sort the data from small to large.

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

Next, let's take a look at the conversion of the varchar type date format in oracle to the date type.

Convert varchar-type date format to date type in oracle

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

M. ma_datetime is the date format of the varchar2 type. The date type is converted first.

(Hours, minutes, or seconds must be added; otherwise, a ora-01830 error is reported)

And convert it to the varchar type as needed.