select fappname, ftimes, convert(varchar(10), fdate, 120) fdate
from tapprequest
where siteid =$siteid$ and fappname=$fappname$
 and convert(varchar(10),fdate,120)>=$fbegdate$ and convert(varchar(10),fdate,120)<=$fenddate$