MYSQL Date Formatting

I always feel like I'm digging around to find a list of date formats for MYSQL.  I then end up doing some trial and error to get the desired format. 

Below is helpful list to refer to for common date formatting.

Example	Results
SELECT NOW()	2020-02-23 19:45:14
SELECT DATE_FORMAT(NOW(),"%a")	Sun
SELECT DATE_FORMAT(NOW(),"%b")	Feb
SELECT DATE_FORMAT(NOW(),"%c")	2
SELECT DATE_FORMAT(NOW(),"%D")	23rd
SELECT DATE_FORMAT(NOW(),"%d")	23
SELECT DATE_FORMAT(NOW(),"%e")	23
SELECT DATE_FORMAT(NOW(),"%f")	0
SELECT DATE_FORMAT(NOW(),"%H")	19
SELECT DATE_FORMAT(NOW(),"%h")	7
SELECT DATE_FORMAT(NOW(),"%I")	7
SELECT DATE_FORMAT(NOW(),"%i")	45
SELECT DATE_FORMAT(NOW(),"%j")	54
SELECT DATE_FORMAT(NOW(),"%k")	19
SELECT DATE_FORMAT(NOW(),"%l")	7
SELECT DATE_FORMAT(NOW(),"%M")	February
SELECT DATE_FORMAT(NOW(),"%m")	2
SELECT DATE_FORMAT(NOW(),"%p")	PM
SELECT DATE_FORMAT(NOW(),"%r")	7:45:14 PM
SELECT DATE_FORMAT(NOW(),"%S")	14
SELECT DATE_FORMAT(NOW(),"%s")	14
SELECT DATE_FORMAT(NOW(),"%T")	19:45:14
SELECT DATE_FORMAT(NOW(),"%U")	8
SELECT DATE_FORMAT(NOW(),"%u")	8
SELECT DATE_FORMAT(NOW(),"%V")	8
SELECT DATE_FORMAT(NOW(),"%v")	8
SELECT DATE_FORMAT(NOW(),"%W")	Sunday
SELECT DATE_FORMAT(NOW(),"%w")	0
SELECT DATE_FORMAT(NOW(),"%X")	2020
SELECT DATE_FORMAT(NOW(),"%x")	2020
SELECT DATE_FORMAT(NOW(),"%Y")	2020
SELECT DATE_FORMAT(NOW(),"%y")	20