MONTH(date) returns the month for date, in the range 0 to 12. : MONTH : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » MONTH »

MONTH(date) returns the month for date, in the range 0 to 12.


mysql>
mysql> SELECT MONTH('1998-02-03');
+---------------------+
| MONTH('1998-02-03') |
+---------------------+
|                   2 |
+---------------------+
1 row in set (0.00 sec)

mysql>

Related Scripts with Example Source Code in same category :

MONTH('2005-00-00');
Get Month name of the employee's start date
Use month function with data in a table
Use month function in where clause
Combine Month function and Date_add function

MySQL TUTORIALS

Date Time Functions
» MONTH

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

MONTH(date) returns the month for date, in the range 0 to 12. : MONTH : Date Time Functions MySQL TUTORIALS

MySQL TUTORIALS » Date Time Functions » MONTH »

MONTH(date) returns the month for date, in the range 0 to 12.

Leave a Comment / Note

MySQL TUTORIALS