sql server procedure list on created date

SELECT name,create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 500
order by create_date asc
-----------------------------------------------------



SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date desc
or
SELECT
    name,
    create_date,
    modify_date
FROM sys.procedures
order by create_date asc









---------------------------
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 30
---------------------

2 down vote

SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 -------------------------------------- SELECT name,create_date, modify_date FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 30