Occasionally the database under design becomes more than a one-off project. For example, the data mart or data warehouse might act as a profit center for the organization, and as a solution sold to ...
When designing a Data Warehouse we usually create a dedicated Time dimension table so that our Business Analysts can analyze the data by Year by Quarter by Month or whatever time period they require.