Date Time MySQL

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 %