How to get date only with put Time

Question

Hi ,

1.      i want in sql server table  between date  is not work if it  is  front end of the windows application date not suport to generate report   plz give a valueble solution for that convert(varchar(24),p.Transactiondate,113) between '2016-07-01' and '2016-07-15'