select COUNT(*) FROM pos_billstate b WHERE Covert(VARCHAR,b.doneTime,120) LIKE '2019-06-10%'
为什么要转一下,而且要用 like 去查