Mysql to convert the varchar type to date type method detailed _mysql

As shown in the following table:

Use the Str_to_date function first, 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 an order by a desc;

Next, let's look at the date format conversion dates type of varchar in Oracle

varchar type date format conversion 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, first converting the date type

(must be added minutes or seconds, otherwise reported ora-01830 error)

And then convert to varchar type at whim.