title: Convert Nvarchar DD/MM/YYYY to YYYY-MM-DD in SQL Query
body: <p>Hi I have a column in my 'Users' table called 'PersonalDetails_DOB'.</p>
  
  <p>The data type is a NVARCHAR(10) and the 'format' the data is currently in DD/MM/YYYY.</p>
  
  <p>I want to change the format to YYYY.MM.DD or YYYY-MM-DD, how would I do this? </p>
  
  <p>I have already tried a running a query in SQL:</p>
  
  <pre><code> SELECT CONVERT(nvarchar(10), PersonalDetails_DOB, 102) as
   'PersonalDetails_DOB' FROM Users;
  </code></pre>
  
  <p>Nothing happens and it doesn't change any date from e.g. 06/02/1967 to 1967.02.06</p>