Date range between result not getting
Hi,I have 'compdate' column value as 2018-11-06 09:27:17.000 and passing values to fromdate and todate range as '06/11/2018' and '06/11/2018'
I tried below query but no output came.
select comp_date from complaints where comp_date between '06/11/2018' and '06/11/2018'
can you correct my query.
Regards,
Ayesha