List the create and last modified date of Routines in MySQL / MariaDB

Check the created and last modified date of Routines:

SELECT ROUTINE_SCHEMA as schemaname,
SPECIFIC_NAME AS STOREDPROCEDURENAME,
CREATED AS CREATEDATE,
LAST_ALTERED AS LASTMODIFIEDDATE
FROM
INFORMATION_SCHEMA.ROUTINES where ROUTINE_SCHEMA = 'dbname';

Check created and last modified for particular routines:

SELECT ROUTINE_SCHEMA as schemaname,
SPECIFIC_NAME AS STOREDPROCEDURENAME,
CREATED AS CREATEDATE,
LAST_ALTERED AS LASTMODIFIEDDATE
FROM
INFORMATION_SCHEMA.ROUTINES where ROUTINE_SCHEMA = 'dbname' and ROUTINE_NAME = 'procedurename';

Check created and last modified in last 7 days in MySQL / MariaDB:

-- Check last created procedures in 7 days:
SELECT
SPECIFIC_NAME AS STOREDPROCEDURENAME,
CREATED AS CREATEDATE,
LAST_ALTERED AS LASTMODIFIEDDATE
FROM
INFORMATION_SCHEMA.ROUTINES 
where CREATED >= DATE_ADD(now(), INTERVAL -7 DAY);


--Check last altered procedure in 7 days
SELECT
SPECIFIC_NAME AS STOREDPROCEDURENAME,
CREATED AS CREATEDATE,
LAST_ALTERED AS LASTMODIFIEDDATE
FROM
INFORMATION_SCHEMA.ROUTINES 
where LAST_ALTERED >= DATE_ADD(now(), INTERVAL -7 DAY);