Use the DATETIME datatype. This will store the value in a universal format. You then simple control the display format from your application. And if u want to make change from your procedure just use following:
SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY] u can give datetime column name in place of GETDATE()
You can’t control the format in which dates are stored in the database. You can only control the way they are displayed.
<b>To insert into a datetime column you need to enclose the values in single quotes.</b>
You might want to take a look at this article:
<a href=”http://www.databasejournal.com/features/mssql/article.php/10894_2191631_1/Working-with-SQL-Server-DateTime-Variables.htm”>Working with SQL Server Date/Time Variables</a>