CAST and CONVERT (Transact-SQL)
Converts an expression of one data type to another in SQL Server 2014. ... Important By default, SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is inter...