How to get created stored procedures in last 2 weeks?

Is there a way I can detect开发者_如何学编程 when was a stored procedure created/modified, so I can get a list of what has been altered in the last 2 weeks?

Check information_schema.routines in mysql.

ROUTINE_NAME is column name

CREATED is created date

LAST_ALTERED is modified date

select ROUTINE_NAME
from information_schema.routines
where DATEDIFF(CURDATE(),created) < 14