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, 244🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...