Collections:
MONTH() - Month of Year
How to extract the month of year from a given date using the MONTH() function?
✍: FYIcenter.com
MONTH(date) is a MySQL built-in function that returns the month of year from a given date. For example:
SELECT MONTH('2023-02-03'), MONTH(NOW()), NOW(); -- +---------------------+--------------+---------------------+ -- | MONTH('2023-02-03') | MONTH(NOW()) | NOW() | -- +---------------------+--------------+---------------------+ -- | 2 | 11 | 2023-11-15 08:19:34 | -- +---------------------+--------------+---------------------+
Reference information of the MONTH() function:
MONTH(date): int Returns the month for date, in the range 1 to 12 for January to December, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero month part. Arguments, return value and availability: date: Required. The date to extract the month of year from. int: Return value. The month of year. Available since MySQL 4.
Related MySQL functions:
2023-11-17, 248🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...