Format date without changing data type to varchar : <p>Today I was working with SQL and I was creating view in sql server , come to know that after convertng and formatting date time value dd-mm-yyyy date data type get changed </p>

<p>So my quest is , is there any way to convert or format date in dd-mm-yyyy without changing data type of column of view in sql server </p>
