To Find Created Date and Modified Date in StoredProcedure in SQL

SELECT create_date,modify_date,name FROM sys.objects where type = 'p'

ORDER BY modify_date DESC