See Server configuration: two digit year cutoff for information about two-digit year values. enddate See startdate. Return types int Return value The int difference between the startdate and enddate, expressed in the boundary set by datepart. For example, SELECT DATEDIFF(day, '2036-03-01', ...
SQL Server provides the two digit year cutoff configuration option to change the cutoff year used by SQL Server. This allows for the consistent treatment of dates. We recommend specifying four-digit years. 3 Input when you convert to datetime; output when you convert to character data. 4 ...