在没有时间的SQL中查询日期时间

I'm trying to write a SQL query which should just pick the count with specific date not time.I'm trying to write a SQL query which should ju