MONTHNAME(date) returns the full name of the month for date. : MONTHNAME : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » MONTHNAME »

MONTHNAME(date) returns the full name of the month for date.

The language used for the name is controlled by the value of the lc_time_names system variable.


mysql>
mysql> SELECT MONTHNAME('1998-02-05');
+-------------------------+
| MONTHNAME('1998-02-05') |
+-------------------------+
| February                |
+-------------------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

SELECT MONTHNAME('1989-07-20');
An illegal date returns a NULL result

MySQL TUTORIALS

Date Time Functions
» MONTHNAME

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

MONTHNAME(date) returns the full name of the month for date. : MONTHNAME : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » MONTHNAME »

MONTHNAME(date) returns the full name of the month for date.

Leave a Comment / Note

MySQL TUTORIALS