title: How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?
body: <p>I'm using SQL Server 2008 R2. I want to convert the system date to this format: <code>dd/mm/yy</code> </p>
  
  <pre><code>"2013-01-01 00:00:00.000" to "Score Calculation - 10/01/13".
  </code></pre>
  
  <p>My column contains the data: </p>
  
  <pre><code>1. DMS01A13010101
  2. RMS01A13010201
  3. 44
  4. 2013-01-01 00:00:00.000
  </code></pre>
  
  <p>What I want: if the record has <code>2013-01-01 00:00:00.000</code> in this format then only I change to <code>Score Caculation - dd/mm/yy</code></p>
  
  <p>My code is,</p>
  
  <pre><code>select 
     case 
        when (CHARINDEX(D30.SPGD30_TRACKED_ADJUSTMENT_X, '-*') &gt; 0 or 
              CHARINDEX(D30.SPGD30_TRACKED_ADJUSTMENT_X, '*-') &gt; 0) 
        then 'Score Calculation - ' + CONVERT(VARCHAR(8), D30.SPGD30_TRACKED_ADJUSTMENT_X, 1) 
      end checkthedate 
  from 
      CSPGD30_TRACKING D30
  </code></pre>