Select statement to get all records older than 24 hours
Posted on 2006-05-12
I am trying to create a select statement that show all the records that are older than 24 hours. I do not want to show all records that are a day old. I am looking for comparing if it has been longer than x number of hours. The sql needs to be flexible enough so I can plug in an arbitrary number of hours (like 6, 12 or 24) and then get all of those records back.