Q:

SQL Express storing date in MM/DD/YYYY format

I have an ASP.NET program that is writing date to an SQLExpress Database date field in DD/MM/YYYY. 
When I look at the data in SQL Express it is stored as mm/dd/yyyy. 
How can I configure it to store in DD/MM/YYYY format? 

A:

This is not possible, as the date is internally stored as a number, the DD/MM/YYYY or MM/DD/YYYY format is only the display format of the data.  You can, however, change the way the data are converted to a string by SQL functions...

