Purpose

The purpose of this article is to teach you the process of setting up the two digit year cutoff option in Microsoft SQL Server 2000.

To Set the Two Digit Year Cutoff Option

Two digit year cutoff option is used to specify an integer from 1753 to 9999 that represents the cutoff year for interpreting two-digit years as four-digit years. A two-digit year that is less than or equal to the last two digits of the cutoff year is in the same century as the cutoff year. A two-digit year that is greater than the last two digits of the cutoff year is in the century that precedes the cutoff year. For example, if two digit year cutoff is 2049 (the default), the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950. Microsoft SQL Server uses 2049 as the cutoff year for interpreting dates; OLE Automation objects use 2030. You can use the two digit year cutoff option to provide consistency in date values between SQL Server and client applications. However, to avoid ambiguity with dates, use four-digit years in your data.

Following steps describe you the step by step details of the process of setting up the two digit year cutoff option:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, click the Properties, and now click the Server Settings. tab.

3. Now, under Two digit year support, enter a value for two year cutoff option.

4. Click OK.