adam gills

adam gills

  • NA
  • 65
  • 14.3k

retrieve data between two dates

Nov 3 2016 9:29 AM

select count(DISTINCT pr.proip)as ipcount,pr.prousername,pr.prodate from processinfo pr
right join processinfo pf on pr.prousername=pf.prousername
where pf.prousername='pk'
and convert(nvarchar,pr.prodate)>= '28-10-2016' and convert(nvarchar,pf.prodate)<= '02-11-2016'
group by pr.prousername,pr.prodate
and result is below-
 
I want to ask why  "02-11-2016" data is not shown while "02-11-2016" data is available in table.
please tell me how to fetch record between two dates
 

Answers (3)