title: Convert nvarchar to datetime sql server
body: <p>I try to convert <code>2016/07/15</code> (nvarchar format)  to this <code>datetime</code> format  <code>2016-07-15 00:00:00</code> in sql server. But i need the time part to be the current time. can any one help ?  </p>
  
  <p>This is my sp:</p>
  
  <pre><code>declare @DateTime varchar(50)
  set @DateTime = '2016/07/15'
  select convert(varchar, cast(@DateTime as datetime), 120) 
  </code></pre>