How to track the time of removal from publication of an ad?

Question

MySQL

There is a table with ads, each ad has a date when this ad should be removed from publication. The question is how to constantly view this time? I know there are crons, but I'll have to set it to run every 10 minutes. The question is, can this be done in a more elegant way? It's just that there are many such examples, how to implement it?

Answer 1

Why keep track of it. Do it at the application level. Those. When you select ads to display on a page, select those ads that have an "unpublished date" greater than the current date.