Date and Time data types Posted on January 8, 2011 Someone asked me why storing datetime values seem to allow a maximum year of 2079. [Read More] Tags: datetime data types SQL Server 2005 Coding Practices T-SQL Programming Database Design Development SQL Server 2000 T-SQL Programming Database Migration