How to convert string to datetime type in mysql

Two conversion methods: 1. Use the str_to_date() function to format a string and convert it into a date and time value according to the specified format. The syntax is "str_to_date (string value, conversion format)". 2. Use the CAST() function to convert the specified string value to the datetime data type, the syntax is "CAST (string value AS datetime)".

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

MySQL DATETIME type

The DATETIME type is used for values ​​that need to contain both date and time information, and requires 8 bytes for storage. The date format is 'YYYY-MM-DD HH:MM:SS', where YYYY represents the year, MM represents the month, DD represents the day, HH represents the hour, MM represents the minute, and SS represents the second.

MySQL method of converting string to datetime type

Method 1: Use str_to_date() function

str_to_date() is a specialized string to date function that can convert a string into a date and time value.

str_to_date(str, format)

• str: ​​Required. A string to be formatted as a date

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

SELECT STR_TO_DATE('21,5,2022','%d,%m,%Y');

SELECT STR_TO_DATE("2022,6,14 10,40,10", "%Y,%m,%d %h,%i,%s");

The CAST() function is used for type conversion to convert a value (of any type) to a specified data type.

Syntax for converting string to datetime type

CAST(字符串值 AS datetime)

Example:

SELECT CAST("2008.08.09 08:09:30" AS DATETIME);

[Related recommendations:

】

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