1. Date converted to the specified format: date_format (date, format)
2, int type time converted to the specified format: from_unixtime (Unix_timestamp,format)
Format the date value according to the format string:
%s,%s two digits in seconds (00, 01, ..., 59)
%I,%I two digits in the form of points (00, 01, ..., 59)
%H two-digit hours, 24 hours (00,01, ..., 23)
%h Two-digit hours, 12 hours (01,02, ..., 12)
%k digital form of hours, 24 hours (0,1, ..., 23)
%l digital form of hours, 12 hours (1, 2, ..., 12)
%T 24-hour time form (HH:MM:SS)
%r 12-hour time format (hh:mm:ss AM or Hh:mm:ss PM)
%p am or PM
%W the name of each day of the week (Sunday, Monday, ..., Saturday)
%a the abbreviation of the name of each day of the week (Sun, Mon, ..., Sat)
%d two digits for the number of days in the month (xx,,..., 31)
%e number representation of days in the month (1, 2, ..., 31)
%d The English suffix indicates the number of days in the month (1st, 2nd, 3rd,... )
%w number of days in the week (0 = Sunday, 1=monday, ..., 6=saturday)
%j three-digit number of days in the year (001, 002, ..., 366)
%u weeks (0, 1, 52), where Sunday is the first day of the week
%u weeks (0, 1, 52), where Monday is the first day of the week
%M month name (January, February, ..., December)
%b Abbreviated month name (January, February,...., December)
%m Two digit month (01, 02, ..., 12)
The month of%c numbers (1, 2, ...., 12)
%Y Four-digit year
%y Two-digit year
Percent direct value "%"
"Mysql" Date time formatting