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, 1645🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Happens to the Current Transaction If a START TRANSACTION Is Executed in MySQL? If you are in a...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...