Collections:
PERIOD_DIFF() - Difference of Year-Month Periods
How to calculate the difference between two year-month periods using the PERIOD_DIFF() function?
✍: FYIcenter.com
PERIOD_DIFF(P1, P2) is a MySQL built-in function that
calculates the difference between two year-month periods.
For example:
SELECT PERIOD_DIFF(201802, 201703), PERIOD_DIFF(201703, 201802); -- +-----------------------------+-----------------------------+ -- | PERIOD_DIFF(201802, 201703) | PERIOD_DIFF(201703, 201802) | -- +-----------------------------+-----------------------------+ -- | 11 | -11 | -- +-----------------------------+-----------------------------+
Reference information of the PERIOD_DIFF() function:
PERIOD_DIFF(P1, P2): int Returns the number of months between periods P1 and P2. P1 and P2 should be in the format YYMM or YYYYMM. Arguments, return value and availability: P1: Required. The year-month period to be subtracted from. P2: Required. The year-month period to be subtracted. int: Return value. The difference in months. Available since MySQL 4.
Related MySQL functions:
⇐ PERIOD_ADD() - Adding Months to Period
2023-11-17, 1377🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...