基于时间在数据库中生成事件

I am wondering if there is any method available to implement event trigger based on time. Lets say i want to deleted/modify a record in a certain time span for example in two days/48 hrs automatically,do i ve to implement something via code for checking it everyday? or database provide any functionality that makes life easier to check the time automatically to trigger the event. Thanks in advance.I am wondering if there is any method available