HOWTO: Using SQL DMO to Print Date in Regional Format (220918)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q220918 SUMMARY
This article demonstrates how to use two different methods using SQL Distributed Management Objects (DMO) to return dates formatted to a specific regional locale.
By default, the date format for SQL server is in U.S. date format MM/DD/YY, unless a localized version of SQL Server has been installed. The SET DATEFORMAT statement and sp_addlanguage will not change the display format for dates.
REFERENCES
SQL Server 7.0 Books Online, topic: "SQL-DMO"
Modification Type: | Major | Last Reviewed: | 11/3/2003 |
---|
Keywords: | kbDatabase kbhowto KB220918 |
---|
|