Mega Code Archive
Common used flags for DATE_FORMAT()
<![CDATA[
Sequence Meaning
%Y Four-digit year
%y Two-digit year
%M Complete month name
%b Month name, initial three letters
%m Two-digit month of year (01..12)
%c Month of year (1..12)
%d Two-digit day of month (01..31)
%e Day of month (1..31)
%r 12-hour time with AM or PM suffix
%T 24-hour time
%H Two-digit hour
%i Two-digit minute
%s Two-digit second
%% Literal %
]]>