SQL - Converting String to Date and Time
<p>I need to convert a value to a SQL Server <code>DateTime</code>.</p>

<p>Data looks like below :</p>

<ul>
<li>20161021-12:55:16.000</li>
<li>20161021-13:22:09.974</li>
</ul>

<p>I tried </p>

<pre><code>CONVERT(DATE, '20161021-12:55:16.000', 102) 
</code></pre>

<p>and it throws an error.</p>

<p>Can I get help in SQL to convert these samples into a valid date time?</p>

<p>Also these values are in UTC.</p>

<p>I need to convert them to EST.</p>

<p>Appreciate your help.</p>