title: Can I change date format of SQL Server table permanently?
body: <p>I have 2 tables in my database.</p>
  
  <ol>
  <li>Customers_Details</li>
  <li>Transaction</li>
  </ol>
  
  <p>Both tables have a <code>date</code> column. I want to change the date format from <code>YYYY-MM-DD</code> to <code>DD-MM-YYYY</code> permanently for both tables.</p>
  
  <p>Can i do it in one query or do I have to write separate query for each table?</p>
  
  <p>The query which I have written is not changing the format of date permanently. </p>
  
  <pre><code>select 
      [customer_ID], [Gender], [Area_code],
      convert(varchar, dob, 105) as DOB 
  from 
      [dbo].[customer_details]
  </code></pre>