Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Using Patterns with Non-String Values
Function value test                     Pattern match test
YEAR(d) = 1976                          d LIKE '1976-%'
MONTH(d) = 4                            d LIKE '%-04-%'
DAYOFMONTH(d) = 1                       d LIKE '%-01'