Monthname

Description

Syntax

VARCHAR MONTHNAME (DATE)

Month name corresponding to return date

The parameter is Date or Datetime type

example

  1. mysql> select monthname('2008-02-03 00:00:00');
  2. +----------------------------------+
  3. | monthname('2008-02-03 00:00:00') |
  4. +----------------------------------+
  5. | February |
  6. +----------------------------------+

keyword

MONTHNAME