You can't - a date time field is always stored as a internal binary
amount. The formatting is dependent on the language settings. It's not
in how you store it, but how it's been set to be displayed.
Author, Professional SQL Server Programming Series
Check out www.ProfessionalSQL.com! It's new and improved and getting
better by the day!
From: Sammy Msafiri [mailto:sammy@s...]
Sent: Wednesday, January 31, 2001 8:06 AM
To: SQL Server
Subject: [sql_server] Date Format
Can i set the date format in a database to have all collumns in any
hold date with certain format e.g.