Hi,
How can i change the default DateTime Value in SQL Server.
when i query using DBCC USEROPTIONS, it showing DataTime value as 'mdy'. now i want change it to 'dmy'. Is this possible
Thanks,
Kedar
Default DateTime value in SQL server
Hot Topic
- XSL Character Count
- FormsAuthentication.SignOut - no redirect wanted
- CreateObject in C#
- Regarding creation of web service
- DirectoryServices - Get users from active directory
- Assembly Security - Where to start?
- class design question
- How to Update Stored Procedures when they have changed
- Framework 2.0 with MS CMS2002
- AccessViolationException with C# Ping class
.NET Development
- where can i get information on web services, from the basics
- Failed to access IIS metabase
- How can I make my GUI more responsive during a loop?
- Bitwise byte operators ?
- RSACryptoServiceProvider to encrypt/decrypt with non-XML keys
- Can I run a 16-bit app on Windows Vista?
- Serialize multi dimensional arrays?
- getting a connection string from a text file
- how to add a child node
- GC.Collect() freezes for several seconds on gen 2 collection
Default DateTime value in SQL server
SunHunter
This won't change the SQL Server default but you can accomplish the formatting in your select statement.
SELECT CONVERT(varchar,<your date field>,103) AS <your date field>
FROM <your table>
The 103 tells SQL Server to format the output to dd/mm/yyyy. There are a number of formatting options you can use. Look in SQL Server Books Online for the CONVERT function.