Convert sql server data format

Question

Well, I need to convert the data in sql server to dd/mm/yyyy I need an update or something that can help me. Screenshot of the table column below, as it is now:

I need you to stay 03-10-2016 for example.

Answer 1

This is only the default display format within the database, the date information itself is correct and has nothing to change. If you want to return the formatted date as mentioned, you will need to do something like this

SELECT CONVERT(VARCHAR(19),GETDATE(),105)

The last parameter is that it determines how the formatting will come, for more details of which numbers are possible: http://www.w3schools.com/sql/func_convert.asp

Answer 2

You can try using:

SELECT CONVERT(VARCHAR(10),GETDATE(),110)

There are other options at: http://www.w3schools.com/sql/func_convert.asp