Hello,
I am looking into making a scheduling table for an application server. I want to store the last time ran in a datetime field, and the time interval in another field (like 1 hour, or 6 months). I will then compare those two fields to see if it is time to run it again.

What would be the best way to store a time interval? I'm sure I could do it with a datetime field, but is there a better way?

Thanks,
Mike