MySQLDate/Time FunctionsSTR_TO_DATE
DATE_FORMAT

STR_TO_DATEDate/Time Functions

DATE_ADD

Parses a string into a date value.

Syntax

STR_TO_DATE(str, format)

Example

Enter values below to update the example in real time.

parsed_date
-- 문자열을 날짜로 파싱
SELECT STR_TO_DATE('27-06-2024', '%d-%m-%Y') AS parsed_date;