Format date for SQL

It is important to specify the date format before passing it into a store procedure to ensure the day and month do not get mixed up. This is achieved using the following.


string date = "13/05/2010";
Response.Write(date).ToString("MM/dd/yyyy");