Date Time MySQL

%f               microseconds                                     000000 to 99999
%S or %s         seconds, two-digit                               00 to 59
%i               minutes, two-digit                               00 to 59
%k               hours (24-hour clock)                            0 to 23
%H               hours, two-digit, 0 to 23 o'clock                00 to 23
%l               hours (12-hour clock)                            1 to 12
%h or %I         hours, two-digit, to 12 o'clock                  01 to 12
%T               24-hour clock                                    00:00:00 to 23:59:59
%r               12-hour clock                                    12:00:00 AM to 11:59:59 PM
%p               AM or PM                                         AM, PM