<p>I need to change the date format from US (mm/dd/YYYY) to UK (dd/mm/YYYY) on a single database on a SQL server machine.</p>

<p>How can this be done?</p>

<p>I've seen statements that do this for the whole system, and ones that do it for the session, but I can't change the code now as it will have to go through QA again, so I need a quick fix to change the date time format.</p>

<p><strong>Update</strong></p>

<p>I realize that the date time has nothing to do with how SQL Server stores the data, but it does have a lot to do with how it parses queries.</p>

<p>I'm chucking raw data from an XML file into a database. The dates in the XML file are in UK date format.</p>

You do realize that format has nothing to do with how SQL Server stores datetime, right?
You can use
```
set dateformat
```
for each session. There is no setting for database only.
If you use parameters for data insert or update or where filtering you won't have any problems with that.