SQL Server help

How to convert a date type in a stored procedure:

convert ( nvarchar, Orig_Date_Type, 23) as DATE :

This will return the date in "yyyy-MM-dd" format.