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 you want to make change from your procedure just use following:
SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY]
You 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.
To insert into a datetime column you need to enclose the values in single quotes.
You might want to take a look at this article: Working with SQL Server Date/Time Variables.