Is there a way to store days, weeks, or months in the database. I'm not talking about dates (like December 13, 2012), but about amounts of time, like 2 weeks, 5 days, or 6 months.
One of the suggestions I found was this: Best way to store time (hh:mm) in a database, in which you store minutes in the database as integers and manipulate them as you need.
Another one, Best way to store span on time in a MySQL database?, talked about simply using a time datatype, but this has a very low range limit.
Is there a more clean way to accomplish this? Thanks