MySql 获取整点数据

淮安气象局中用到的部分数据

SELECT * FROM `db_m_watchitem` where MINUTE(watchTime)=0 AND SECOND(watchTime) =0;