How to convert date to string in mysql

Mysql has two ways to convert dates to strings: 1. Use the date_format() function to format the date value according to the specified format and return the formatted date string. The syntax "date_format(specified Date, specified format)". 2. Use the time_format() function to convert the specified date and time into a string, the syntax is "time_format (specified date and time, specified format)".

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

Two methods for mysql to convert date and time into string

1. Use the date_format() function

The date_format() function can format date values ​​according to the specified format and return the formatted date string

DATE_FORMAT(date, format)

• date Required. The date to be formatted

• format is required. The format to use. Can be one or a combination of the following values:

SELECT DATE_FORMAT("2022-06-15", "%Y %m %d");

SELECT DATE_FORMAT("2022-06-15", "%M %d %Y");

2. Use the time_format() function

time_format(time,format)

这用起来就像DATE_FORMAT()函数，但格式字符串格式说明包含只有几个小时，分钟和秒。

如果时间值包含小时的部分，其可大于23，在%H 和 %k小时格式说明符产生的值范围通常大于0..23。另小时格式说明符产生小时值为模12。

示例：

SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l');

【相关推荐：mysql视频教程】

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