MySQL - date parts

SELECT SECOND("2020-06-29 09:41:42"); 
#-->42
SELECT SECOND("23:59:59");
#-->59
SELECT SECOND(CURRENT_TIME());

SELECT MINUTE("2020-06-29 09:41:42"); 
#-->41

SELECT HOUR("2020-06-29 15:41:42"); 
#-->15

SELECT DAY("2020-06-29 09:41:42"); 
#-->29
SELECT DAYOFMONTH("2020-06-29");
#-->29
SELECT DAYOFWEEK("2020-06-29");
#-->2 = Monday
SELECT DAYOFYEAR("2020-06-29");

#-->181 (count by yourself... :) )

SELECT MONTH("2020-06-29 09:41:42"); 
#-->6
SELECT MONTHNAME("2020-06-29 09:41:42"); 
#-->June

SELECT YEAR("2020-06-29 09:41:42"); 
#-->2020

SELECT DATE("2020-06-29 09:41:42"); 
#-->2020-06-29

SELECT TIME("2020-06-29 09:41:42"); 
#-->09:41:42