title: How to Remove Trailing Zeroes from a datetime column in SQL Server
body: <p>I have a column in a SQL Server database of datatype <code>DATETIME</code>.</p>
  
  <p>Currently the value is in this format: 2054-12-31T00:00:00.0000000</p>
  
  <p>I want to convert this column values into this format : 2054-12-31T00:00:00</p>
  
  <p>This conversion of value should happen while I select the column in <code>SELECT</code> query statement at run time</p>