sql - error Display Datetime in Specific Format -

select mydate  tble_xxx  convert(varchar(20), mydate, 120)  between convert(varchar(20), (@startdate, 'yyyy-mm-dd hh:m:ss:mmm', 'en-us') , 120)  , convert(varchar(20), (@enddate, 'yyyy-mm-dd hh:m:ss:mmm', 'en-us'), 120) 

when try date between data , change specific format datetime, error occured. please me...

select mydate  tble_xxx  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)  , convert(varchar(20), (n'06/04/2015 12:00:00', 'yyyy-mm-dd hh:m:ss:mmm', 'en-us'), 120)  

try this

declare @startdate datetime='08/01/2015 12:00:00' declare @enddate datetime='06/04/2015 12:00:00'  select mydate  tble_xxx  cast(mydate date) between cast(@startdate date) , cast(@enddate date)