17,377
社区成员
发帖
与我相关
我的任务
分享
select * from tablename
where to_char(col,'yyyymmdd') between 20101001 and 20101031
and to_char(col,'hh24mi') between 630 and 900
select * from tb where to_char(时间字段,'YYYY-MM') between '2010-10' and to_char(时间字段,'HH:MI:SS') between '0630' and '0900'