How to read only date from the sql database with time through Sql query

Select Count(*) From BillMast where Cast(Floor(Cast(BillDate as Float)) as datetime) = '" + Billdate.ToString("yyyy/MM/dd") + "'"