Concat string with a Query with DateTime String
<p>I am unable to Add CurrentSystemTime to my Query manually. The Query is stored in a string variable. But the concationation part is giving error:</p>

<p><strong>The Query is:</strong></p>

<pre><code>string myQuery= @"SELECT MAX(ASD.eventDateTime) AS second, R.resourceID,R.resourceLoginID,ASD.agentID
                  FROM AgentStateDetail AS ASD INNER JOIN 
                  Resource AS R ON ASD.agentID = R.ResourceID WHERE ASD.eventDateTime &gt;='" + DateTime.Today.ToString("yyyy-MM-dd h:mm:ss") + "'AND ASD.eventDateTime &lt;='2016-10-18 23:59:59' 
                  GROUP BY R.ResourceID,R.resourceLoginID,ASD.agentID"
</code></pre>

<blockquote>
  <p><strong>The Problem part is</strong>:</p>
  
  <p>WHERE ASD.eventDateTime >='" +
  DateTime.Today.ToString("yyyy-MM-dd h:mm:ss") + "'</p>
  
  <p><strong>Error is:</strong></p>
  
  <p>Represent Text as unicode character Newline in constant.</p>
</blockquote>