title: How to convert datetime to nvarchar while keeping the same format?
body: <p>How do you convert a datetime with timestamp to nvarchar while dropping the microseconds and keeping the same format without using a series of concatenated datepart functions? I looked around, but solution didn't work for me. - </p>
  
  <p><a href="https://stackoverflow.com/questions/13772466/convert-datetime-to-nvarchar-but-keep-format">Convert datetime to nvarchar but keep format</a>
  convert(nvarchar(20), '2012-11-22 06:50:10.000', 20) = Nov 22 2012  6:50AM </p>
  
  <p>Ex.
  DATETIME: 2012-11-22 06:50:10.000 -> NVARCHAR: 2012-11-22 06:50:10</p>