Convert mysqlstr_to_date string to datetime _ MySQL

Convert mysqlstr_to_date string to date bitsCN.com

Mysql str_to_date string to date

Mysql built-in functions use str_to_date () in mysql to convert a string to a date.

Instance:

The separators are the same, and the year, month, and day must be the same.

Select str_to_date ('2014/1/0 12:00:34 AM ',' % m/% d/% y % h: % I: % s % S') as column_name from table_name;

Str_to_date ('2014/1/123', '% m/% d/% Y'); --

Str_to_date ('2014/1/11', '% m/% d/% Y'); -- 11/09

Str_to_date ('11. 09.2011 ',' % m. % d. % Y'); -- 2011-11-09

Str_to_date ('11: 09: 30', '% h: % I: % S'); -- 11:09:30

Str_to_date ('11. 09.2011 11:09:30 ',' % m. % d. % Y % h: % I: % S'); -- 11:09:30

BitsCN.com