-- C是一张表,PUBTIME是DATE类型,时间在某一范围内
WHERE
C.PUBTIME between to_date('2016-01-01 00:00:00','yyyy-mm-dd HH24:mi:ss') and to_date('2017-01-01 00:00:00','yyyy-mm-dd HH24:mi:ss')
DATE 相关
最新推荐文章于 2022-03-30 19:44:10 发布
-- C是一张表,PUBTIME是DATE类型,时间在某一范围内
WHERE
C.PUBTIME between to_date('2016-01-01 00:00:00','yyyy-mm-dd HH24:mi:ss') and to_date('2017-01-01 00:00:00','yyyy-mm-dd HH24:mi:ss')