Shulou(Shulou.com)06/01 Report--

This article is about how to use the DATE_FORMAT function in MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

DATE_FORMAT (date,format): formats the date according to the parameters.

SELECT DATE_FORMAT ('2016-01-16 22 SELECT DATE_FORMAT 2300 SELECT DATE_FORMAT% H% k% I% r% T% S% w') SELECT DATE_FORMAT (' 2016-01-16 22 22 V% T% S% w') SELECT DATE_FORMAT ('2016-01-16 22 22 V% T% S% w') '% Y-%m-%d% HRV% iRO% s')-> Saturday January 2016-> 16th 16 Sat 16 01 Jan 016-> 22 22 10 10:23:00 PM 22:23:00 00 6-> 2016-01-16 22:23:00

The format of format is listed:

% M month name (January... December)

% W week name (Sunday... Saturday)

% D the date of the month with the English prefix (1st, 2nd, 3rd, etc.). )

% Y year, number, 4 digits

% y year, number, 2 digits

% an abbreviated name of the week (Sun... Sat)

Number of days in% d month, number (00. 31)

Number of days in% e month, number (0... 31)

% m month, number (01... 12)

% c month, number (1 …... 12)

% b abbreviated month name (Jan... Dec)

% j days of the year (001... 366)

% H hours (00. 23)

% k hours (0. 23)

% h hours (01 …... 12)

% I hours (01 …... 12)

% l hours (1 …... 12)

% I minutes, number (00. 59)

% r time, 12 hours (hh:mm:ss [AP] M)

% T time, 24 hours (hh:mm:ss)

% s seconds (00. 59)

% s seconds (00. 59)

% p AM or PM

% w days in a week (0=Sunday... 6=Saturday)

% U week (0 …... Here Sunday is the first day of the week

% u weeks (0. Here Monday is the first day of the week

% character%)

TIME_FORMAT (time,format):

The usage is similar to DATE_FORMAT (), but TIME_FORMAT only deals with hours, minutes, and seconds (the rest of the symbols produce a null value or 0)

Thank you for reading! This is the end of the article on "how to use the DATE_FORMAT function in MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.