p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

sql_server thread: Date Format


Message #1 by "Sammy Msafiri" <sammy@s...> on Wed, 31 Jan 2001 19:06:09 +0300
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.

Rob Vieira
Author, Professional SQL Server Programming Series
Check out www.ProfessionalSQL.com! It's new and improved and getting
better by the day!



-----Original Message-----
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
table
hold date with certain format e.g.

dd-mmm-yyyy

Sammy Msafiri

  Return to Index