Inserting date in format DD-MM-YYYY in SQL SERVER 2005

[Rohan rawat]

I have created a table into my database which has a coloumn with datatype defined as DATETIME. The normal SQL date order is MM-DD-YYYY, however I need to enter it in format DD-MM-YYYY.

Is it possible to insert into SQL SERVER database where field is formatted as DATETIME , a date in format DD-MM-YYYY instead in format MM-DD-YYYY
If not possible, can I convert a value posted from ASP.NET web page in format DD-MM-YYYY into the format MM-DD-YYYY using the MySQL syntax or I should use ASP>NET to post the value in YYYY-MM-DD format?

[hericles]

Try this code:
DATE_FORMAT(date,format)

So your code would look like DATE_FORMAT(date, '%d-%m-%Y')

You can read more here: http://www.w3schools.com/sql/func_date_format.asp

Hope that helps,

[catherine sea]

You can check the article on how to convert the date format:http://www.sql-server-helper.com/tips/date-formats.aspx