title: How to separate date and time and show in separate columns in SQL Server?
body: <p>I have a SQL Server table with a column <code>TaskAssignDate</code> which contains data like </p>
  
  <pre><code>2017-09-02 00:00:00.000
  </code></pre>
  
  <p>I want to separate date and time from that column and show the data in different columns.</p>
  
  <p>I have a SQL query like this</p>
  
  <pre><code>select 
      TaskAutoId, UserAutoId,
      CONVERT(varchar, TaskAssignDate, 100) as TaskAssignDate,
      TaskDescription, TaskStartDate,
      CONVERT(varchar, TaskEndDate, 100) as TaskEndDate,
      IsCloseByUser
  from 
      tblTask
  where 
      IsSelfAssign = 1
  </code></pre>
  
  <p>I want to edit the following query, and split my column (<code>taskassigndate</code>) into two columns</p>
  
  <p>What is a right way to do this?</p>