Get records created one hour ago

-- Get stored procedures created one hour ago

SELECT [name], create_date, modify_date FROM sys.objects
WHERE type = 'p'
AND create_date >= DATEADD(hour, -1, getdate())