Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. Extracting Years, Quarters, Months, and Weeks
MySQL has a range of function for extracting numerical data from a date:
YEAR(date)
QUARTER(date)
MONTH(date)
WEEK(date[,firstday])
YEARWEEK(date[,firstday])