title: Convert epoch timestamp to datetime without milliseconds?
body: <p>First of all I know there are several questions out there similar to this, but none of them actually show how to display the date time format without including milliseconds.</p>
  <p>I have this code below:</p>
  <pre><code>SELECT CONVERT(
     DATETIME,
     dateadd(SS,CONVERT(INT, 1354320000), CAST('1970-01-01 00:00:00' as datetime)),
     120
  )
  </code></pre>
  <p>However, the code is including milliseconds but rather I need the format to be like such <code>yyyy-mm-dd hh:mm:ss</code></p>
  <p>Does anyone know an effective way to go about this?</p>