DATE_FORMA T(date, format) format date, 。
DATE_FORMAT( ) DATE DATETIME , 。 format date :
%S, %s ( 00,01, . . ., 59)
%i ( 00,01, . . ., 59)
%H ,24 (00,01, . . ., 23)
%h, %I ,12 (01,02, . . ., 12)
%k ,24 (0,1, . . ., 23)
%l ,12 (1, 2, . . ., 12)
%T 24 (h h : m m : s s)
%r 12 (hh:mm:ss AM hh:mm:ss PM)
%p AM P M
%W ( S u n d a y, Monday, . . ., Saturday)
%a ( Sun, Mon, . . ., Sat)
%d ( 00, 01, . . ., 31)
%e ( 1, 2, . . ., 31)
%D ( 1st, 2nd, 3rd, . . .)
%w ( 0 = S u n d a y, 1=Monday, . . ., 6=Saturday)
%j ( 001, 002, . . ., 366)
% U (0, 1, 52), Sunday
%u (0, 1, 52), Monday
%M (J a n u a r y, February, . . ., December)
%b ( J a n u a r y, February, . . ., December)
%m ( 01, 02, . . ., 12)
%c ( 1, 2, . . ., 12)
%Y
%y
%% “%”
select date_format( ,’%Y-%m-%d’) as ‘ ’ from test