How to convert date to string type in mysql

In mysql, you can use the "select date_format('2008-08-08 08:08:08', '%Y%m%d%H%i%s');" statement to convert the date type is a string.

Recommended: "mysql video tutorial"

MySQL date and time type conversion string

Convert date/time type to string type

date_format(date,format)：date to string

select date_format('2008-08-08 08:08:08', '%Y%m%d%H%i%s');

time_format( time,format): time to string

select time_format('08:08:08', '%H%i%s');

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