Q:

Sql server date Column format

I have one column in SQL Server table with type date and its default setting is yyyy-MM-dd. I want to chage it like dd-MM-yyyy.
How can I do it?

A:

its default setting is yyyy-MM-dd

No, it's not. There is no formatting information at all associated with the field.
The value is not formatted by the database, it's returned only as a point in time. Formatting that value into it's textual representation is done by the applcation that is getting the data from the database.
So, there is nothing that you can do in the database to change how the date value is formatted, you have to change that where the data is displayed.

A:

Are you looking for this ?
SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy

and see other format from here http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/

