Date Functions – Month, Hour, Minute

/*
  Select Month
  Month
  Month Name
  Hour
  Minute
*/

SELECT date, MONTH(date) FROM `try`;

SELECT date, MONTH(date), MONTHNAME(date) FROM `try`;

SELECT date, MONTH(date), MONTHNAME(date), HOUR(date) FROM `try`;

SELECT date, MONTH(date), MONTHNAME(date), HOUR(date), MINUTE(date) FROM `try`;