Questions about time are everywhere: who joined this year, how many hires per month, how long since an order. Date functions pull out parts like the year or month and compute differences between dates. Use them whenever you group or filter by time. They differ the most between databases, so know that SQLite uses strftime while MySQL has YEAR() and DATEDIFF().