Get month of a date : Month : Date Time SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » Date Time » Month »

Get month of a date



SELECT MONTH(CURRENT_DATE);
/*
mysql> SELECT MONTH(CURRENT_DATE);
+---------------------+
| MONTH(CURRENT_DATE) |
+---------------------+
|                  10 |
+---------------------+
1 row in set (0.00 sec)

*/

Related Scripts with Example Source Code in same category :

Have birthdays next month
Birthdays in the upcoming month
Use MONTH to get the month of a date
Use MONTHNAME in where clause
Use MONTH to get the month of a date 2

SQL / MySQL

Date Time
» Month

Date Compare Order
Date Format
Date Function
Date Time Function
Date Type
Day
Month
Time
Year

Backup Load

Command MySQL

Cursor

Data Type

Database

Date Time

Flow Control

Function

Insert Delete Update

Join

Key

Math

String

Trigger

View

Get month of a date : Month : Date Time SQL / MySQL

SQL / MySQL » Date Time » Month »

Get month of a date

Leave a Comment / Note

SQL / MySQL