Premium
Log in

MySQL Function Reference

STR_TO_DATE
Returns date and time based on string and string format
MySQL 8.1
STR_TO_DATE(string, format)
string
Source string with date
format
Date string format
Format componentDescription
%MFull month name(January...December)
%bShort name of the month (Jan...Dec)
%mThe numeric value of the month (01...12)
%dNumeric value of the day of the month (00...31)
%WWeekday name in full(Sunday...Saturday)
%aWeekday name in short (Sun...Sat)
%jDay of the year (001..366)
%YYear as a numeric (4-digit value)
%yYear as a numeric (2-digit value)
%HHour with leading zero in 24-hour format (00...23)
%hHour with leading zero in 12-hour format (01...12)
%iMinutes (00...59)
%sSeconds(00...59)
%fMicroseconds (000000...999999)
%pAM or РМ
Examples
MySQL 8.1
SELECT STR_TO_DATE('November 13, 1998', '%M %d, %Y')