Mysql time format description: www.2cto.com % a abbreviation of the week name % B abbreviation of the month name % c month, the value % D with an English prefix of the day % d day, value (00-31) % e day, value (0-31) % f microsecond www.2cto.com % H hour (00-23) % h hour (01-12) % I hour (01-12) % I minute, value (00-59) % j Year Day (001-366) % k hour (0-23) % l hour (1-12) % M month name % m month, value (00-12) % p AM or PM % r time, 12-hour (hh: mm: ss AM or PM) % S second (00-59) % s second (00-59) % T time, 24-hour (hh: mm: ss) % U Week (00-53) Sunday is the first day of a week % u Week (00-53) Monday is the first day of a week % V Week (01-53) Sunday is the first day of a week, and % X use % v Week (01-53) Monday is the first day of the week, and % x use % W week name % w week day (0 = Sunday, 6 = Saturday) % X years, where Sunday is the first day of the week, 4 digits, and % V Use % x years, where Monday is the first day of the week, 4 digits, and % v Use % Y year, 4 digits % y year, 2 digits