CREATE OR REPLACE PROCEDURE date_calculations AS
    v_future_date DATE;
    v_date_diff NUMBER;
BEGIN
    -- Date addition (Oracle native operator support)
    SELECT SYSDATE + 30  
    INTO v_future_date 
    FROM DUAL;  

    -- Date difference calculation (implicit day difference)
    SELECT TO_DATE('2024-12-31', 'YYYY-MM-DD') - TO_DATE('2024-01-01', 'YYYY-MM-DD')  -- returns day difference [8](@ref)
    INTO v_date_diff 
    FROM DUAL;  

    DBMS_OUTPUT.PUT_LINE('Future Date: ' || v_future_date || ', Days Diff: ' || v_date_diff);  -- string concatenation syntax [1,7](@ref)
END;

DELIMITER //
CREATE PROCEDURE date_calculations()
BEGIN
 DECLARE v_future_date DATE;
 DECLARE v_date_diff INT;  -- type mapped to INT [1](@ref)

 -- Date addition (explicit function form)
 SELECT DATE_ADD(SYSDATE(), INTERVAL 30 DAY)  
 INTO v_future_date;

 -- Date difference calculation (parameter order reversed)
 SELECT DATEDIFF(
    STR_TO_DATE('2024-12-31', '%Y-%m-%d'),  -- format specifier remapping [1](@ref)
    STR_TO_DATE('2024-01-01', '%Y-%m-%d')  -- TO_DATE conversion strategy [5](@ref)
 )
 INTO v_date_diff;

 SELECT CONCAT('Future Date: ', v_future_date, ', Days Diff: ', v_date_diff);  -- output method refactoring [7](@ref)
END //
DELIMITER ;