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 23 %d 23
Day of month without leading zero j 23 %e 23
Day of month with english ordinal suffix jS 23rd %D 23rd
Day name l Saturday %W Saturday
Day name abbreviated D Sat %a Sat
Day number in current week w 6 %w 6 0-Sunday, 6-Saturday
Day number in current year z 265 %j 266 PHP 0-365, MySQL 001-366

Month

Month of year with leading zero m 09 %m 09
Month of year without leading zero n 9 %c 9
Month name F September %M September
Month name abbreviated M Sep %b Sep

Year

Year Y 2017 %Y 2017
Year abbreviated y 17 %y 17

Hour

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

Minute

Minute with leading zero i 49 %i 49

Second

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

Other

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