error Display Datetime in Specific Format
<pre><code>select mydate 
from Tble_xxx 
where CONVERT(varchar(20), mydate, 120) 
BETWEEN CONVERT(varchar(20), (@startdate, 'yyyy-MM-dd HH:m:ss:mmm', 'en-US') , 120) 
AND CONVERT(varchar(20), (@enddate, 'yyyy-MM-dd HH:m:ss:mmm', 'en-US'), 120)
</code></pre>

<p>When I am try to get date between to data and change the Specific Format datetime, then error occured. please Help me...</p>

<pre><code>select mydate 
from Tble_xxx 
where CONVERT(varchar(20), mydate, 120) 
BETWEEN CONVERT(varchar(20), (N'08/01/2015 12:00:00', 'yyyy-MM-dd HH:m:ss:mmm', 'en-US') , 120) 
AND CONVERT(varchar(20), (N'06/04/2015 12:00:00', 'yyyy-MM-dd HH:m:ss:mmm', 'en-US'), 120) 
</code></pre>