Get the current time with now () on the line.
Format the time in the database with Date_forma T (date, format).
Formats a date or date and time value according to format string, and returns the result string.
You can use Date_format () to format a date or datetime value to get the format you want. Format the date value according to the format string:
%s,%s two digits in seconds (00, 01, ..., 59)
%i two digits in the form of points (00, 01, ..., 59)
%H two-digit hours, 24 hours (00,01, ..., 23)
%h,%I Two digits in the form of 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 (H h:m m:s s)
%r 12-hour time format (hh:mm:ss AM or Hh:mm:ss PM)
%p AM or P M
%W the name of each day of the week (S u n d a y, Monday, ..., Saturday)
%a the abbreviation of the name of each day of the week (Sun, Mon, ..., Sat)
%d two digits indicates the number of days in the month (00, 01, ..., 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 = S u n d a y, 1=monday, ..., 6=saturday)
%j three-digit number of days in the year (001, 002, ..., 366)
% U Week (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 (J a n u a r y, February, ..., December)
%b Abbreviated month name (J a n u a r y, 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 "%"
Select Date_format (Date field, '%y-%m-%d ') as ' date ' from test
MySQL Gets the current time function what is the function that formats the date