PRB: Two Digit Year Display of Date Fields in SQL Enterprise Manager (SEM)

ID: Q217034

The information in this article applies to:

Microsoft SQL Server version 7.0

SYMPTOMS

Dates between 1930 and 2029 display in the SQL Enterprise Manager using only the last two digits of the year, while all other years are displayed in their entirety.

CAUSE

Enterprise Manager adopts the User's regional settings for the date format. By default, the regional setting for the short date format is M/d/yy.

RESOLUTION

On the taskbar, click the Start button, point to Settings and then select Control Panel. In the Control Panel dialog box double-click Regional Settings. In the Regional Settings Properties dialog box, select the Date tab. Next, change the value for the Short Date Style from M/d/yy to M/d/yyyy.

REFERENCES

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/y2k/

Additional query words: Y2K, MMC KB2000 Y2Kreviewed

Keywords : SSrvEntMan kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbprb