Mega Code Archive

 

Categories / MySQL / Date Time

 

Time Symbols in DATE_FORMAT, TIME_FORMAT, and FROM_UNIXTIME

%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