PERIOD_ADD Function:- PERIOD_ADD Function is used for adding a specific number of months to a period. Its return format will be YYYYMM Syntax:- PERIOD_ADD(period, number) Example:- SELECT PERIOD_ADD(202203, 21); Output:- 202312 PERIOD_DIFF Function:- PERIOD_DIFF Function
Continue Reading- Home
- SUBDATE