SQL Help Required - query contains all users added the previous day
<p>Given the following SQL query:</p>

<pre><code>SELECT * FROM TableName WHERE creationDate &gt;= GetDate() -1 AND creationDate &lt; GetDate() 
</code></pre>

<p>Could you please let me know How do I get the result for </p>

<blockquote>
  <p>Report contains all users added the previous day</p>
</blockquote>

<p>Here I want to know make the <code>WHERE</code> clause on "creationDate" column on yesterday date, e.g.: </p>

<p><code>DD:MM:YYYY:12:01:00 (AM)</code> and <code>DD:MM:YYYY:11:59:00 (PM)</code>.</p>

<p>I am new to SQL, please help me.</p>