oracle:
select * from tablename where trunc(TM)=to_date('2018-06-20','YYYY-MM-DD')
mysql:
select * from 表名 where to_days(时间字段名) = to_days(now());
sql如何查询某天的所有数据
最新推荐文章于 2023-04-03 22:31:23 发布
oracle:
select * from tablename where trunc(TM)=to_date('2018-06-20','YYYY-MM-DD')
mysql:
select * from 表名 where to_days(时间字段名) = to_days(now());