PHP & MySQL Date Format Reference

Title PHP PHP example MySQL MySQL example Notes
date($format, [$timestamp]) DATE_FORMAT(date, format)

Day & Date

Day of month with leading zero d 16 %d 16
Day of month without leading zero j 16 %e 16
Day of month with english ordinal suffix jS 16th %D 16th
Day name l Tuesday %W Tuesday
Day name abbreviated D Tue %a Tue
Day number in current week w 2 %w 2 0-Sunday, 6-Saturday
Day number in current year z 15 %j 016 PHP 0-365, MySQL 001-366


Month of year with leading zero m 01 %m 01
Month of year without leading zero n 1 %c 1
Month name F January %M January
Month name abbreviated M Jan %b Jan


Year Y 2018 %Y 2018
Year abbreviated y 18 %y 18


24 Hour with leading zero H 07 %H 07
24 Hour without leading zero G 7 %k 7
12 Hour with leading zero h 07 %h 07 %I also works in MySQL
12 Hour without leading zero g 7 %l 7
AM or PM A AM %p AM 'a' can also be used in php for lowercase result.


Minute with leading zero i 49 %i 49


Seconds with leading zero s 09 %s 09 %S also works in MySQL


Microseconds u 000000 %f 000000
Leap year L 0 '1' if leap year, '0' if not. No MySql alternative.
Documentation - date() - date_format()