title: SQL SERVER Convert UTC DATETIME to local date time
body: <p>I have a table with the column CreatedDateTime as shown below : </p>
  
  <pre><code>[CREATED_DATE_TIME] [datetime] NOT NULL DEFAULT GETUTCDATE()
  </code></pre>
  
  <p>When I am retrieving the created date time, it is giving me datetime value in UTC, but I want to show the datetime value in local time.</p>
  
  <p>How can this be achieved?</p>
  
  <p>Looking forward to your answers and thanks in advance.</p>