在我的表中有一个字段存储的是datetime格式“yyyy-mm-dd hh24:mi:ss”。
我想获得10月1号到10月31号之间 早上6点到早上9点之间的数据。请问大侠们 如何写语句啊???
我想获得10月1号到10月31号之间 早上6点到早上9点之间的数据。请问大侠们 如何写语句啊???
解决方案 »
- NOT IN 优化问题,谢谢?
- 在线等 一条SQL语句转成Linq语句
- 请教一个ORACLE分析函数查连续6个月以上数据为0的方法!
- Oracle单表循环
- Oracle9i的OMS服务为什么总是启动不了?
- 编译时报错:必须在程序包体中对其进行定义?怎么回事?
- 高手请指教:ora-00984.列不允许。是什么问题。(在线等待)
- NVL()函数和to_date()函数是什么意思?SQLServer中相对应的函数是什么?
- 请问如何修改oracle用户system的口令?在线等待!!急!!
- 64bit Sqlserver2012 链接服务器连接Oracle10g 32bit已被玩疯
- Oracle sql用时间段判断问题~~续
- 分区表导出失败
where (to_number(to_char(your_date_column,'mi')) between 6 and 9)
and (your_date_column between to_date('20101001','yyyymmdd') and to_date('20101101','yyyymmdd'))
where to_char(col,'dd') between 1 and 31
and to_char(col,'hh24') between 6 and 9
where (to_number(to_char(your_date_column,'hh24')) between 6 and 9)
and (your_date_column between to_date('20101001','yyyymmdd') and to_date('20101101','yyyymmdd'))
where to_char(col,'mm')='10'
and to_char(col,'dd') between 1 and 31
and to_char(col,'hh24') between 6 and 9
select * from your_table
where (to_number(to_char(your_date_column,'hh24')) between 6 and 9)
and (your_date_column between to_date('20101001','yyyymmdd') and to_date('20101101','yyyymmdd'))
select * from tablename
where to_char(col,'yyyymmdd') between 20101001 and 20101031
and to_char(col,'hh24') between 6 and 9
--dateti
--20100909 151515
--20101015 161616
--20111001 171717
--20101015 070707
--sql
select * from yyq_date
where (to_number(to_char(dateti,'hh24')) between 6 and 9)
and (dateti between to_date('20101001','yyyymmdd') and to_date('20101101','yyyymmdd'))
---------------------------------------------------------------------------------------
2010/10/15 07:07:07