Unable to get record from database with Between condition
<p>Dates are Svaing in my datatbase with this format.</p>

<pre><code>04 Feb 2016
04 Mar 2016
04 Mar 2016
04 Mar 2016
04 Mar 2016
</code></pre>

<p>And I am using <br><br></p>

<pre><code> select CONVERT(VARCHAR(20),Convert(datetime,CREATEDATE),106)
 from job
 where CONVERT(VARCHAR(20),Convert(datetime,CREATEDATE),106) 
 between     Convert(VARCHAR(20),Convert(datetime,getdate())-25,106)
         AND CONVERT(VARCHAR(20),Convert(datetime,GETDATE()),106)
</code></pre>

<p>SQL statement for get result from database. But I am unable to get any record.</p>