Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2007-01-12 : 17:10:25
|
| Is it possible to make the date format to dd/mm/yyyy in the database, currently it shows as mm/dd/yyyy.we have few databases which belong to Europe.Thank you very much for the information. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-01-12 : 17:46:25
|
quote:
Originally posted by reddymade
Is it possible to make the date format to dd/mm/yyyy in the database, currently it shows as mm/dd/yyyy.we have few databases which belong to Europe.Thank you very much for the information.
Databases do not have a date format. All dates are stored in the same format internally. The date format only determines how it is displayed.Server logins have a default format determined by their default language. Different logins can have different default languages. You can change the default language for a login. The date format for a connection can be changed at any time using the SET DATEFORMAT command. You can look that command up in SQL Server Books Online.CODO ERGO SUM |
 |
|
|
|
|
|
how to make Date format dd/mm/yyyy in whole DB