MySQL date_format () format the date

MySQL date_format () format the date

 

Date_forma T (date, format) format the date or Date and Time Value Based on the format string, and return the result string.

 

You can use date_format () to format the date or datetime value to obtain the expected format. Format the date value based on the format string:

 

% S, % s two-digit second (,..., 59)

 

% I two-digit score (,..., 59)

 

% H two-digit hour, 24 hours (,..., 23)

 

% H, % I two-digit hour, 12 hours (,..., 12)

 

% K, 24 hours (0, 1,..., 23)

 

% L hour in numeric format (1, 2,..., 12)

 

% T 24-hour time format (H: M: S)

 

% R 12-hour time format (HH: mm: SS am or hh: mm: SS pm)

 

% P am or p m

 

% W name of each day in a week (s u n d a Y, Monday,..., Saturday)

 

% A abbreviation of the name of each day in a week (Sun, Mon,..., SAT)

 

% D indicates the number of days in a month (00, 01,..., 31)

 

% E indicates the number of days in a month (1, 2,..., 31)

 

% D indicates the number of days in a month (1st, 2nd, 3rd ,...)

 

% W represents the number of days in a week (0 = s u n d a Y, 1 = Monday,..., 6 = Saturday)

 

% J represents the number of days in a year in three digits (001,002,..., 366)

 

% U Week (0, 1, 52), where Sunday is the first day of the week

 

% U Week (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 double-digit month (01, 02,..., 12)

 

% C indicates the month (1, 2,..., 12)

 

The year in the format of % Y.

 

The year in double-digit % Y format.

 

% Direct value "%"

 

Select date_format (Date Field, '% Y-% m-% D') as 'date' from test