Converting String to Datetime2
<p>I am trying to convert </p>

<pre><code>@string='25/05/2016 09:00' 
</code></pre>

<p>to <code>2016-05-25 09:00</code>.</p>

<p><code>@string</code> is concatenation of <code>@string2='25/05/2016'</code> and <code>@string3='09:00'</code></p>

<p>When I try to do this using </p>

<pre><code>CONVERT(datetime, '25/05/2016 09:00') 
</code></pre>

<p>I get the following error</p>

<blockquote>
  <p>The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.</p>
</blockquote>

<p>Please help, thanks.</p>