title: How to get a time and Date Separately?
body: <p>Using SQL Server 2005</p>
  
  <p>Table1</p>
  
  <p>Time</p>
  
  <pre><code>12/05/2009 08:30:49
  12/05/2009 17:00:00
  13/05/2009 21:00:00
  </code></pre>
  
  <p>...,</p>
  
  <p>Above Table Both values are same column, Here I want to separate column like Date and Time</p>
  
  <p>Expected Output</p>
  
  <pre><code>Date       Time
  
  12/05/2009 08:30:49
  12/05/2009 17:00:00
  13/05/2009 21:00:00
  </code></pre>