Question: how to change default date format in sql server 2008?
Answer: Solution 3. It,s very simple just write the following query to get the default date in dd/mm/yyyy. select convert(varchar,convert(datetime,getdate(),105),103).