第1个回答 2013-07-20
select 日期 from 表名 where 日期 between '2009-06-05' and '2009-06-08'
第2个回答 2013-07-20
where 日期字段>='2009-06-05' and 日期字段<='2009-06-08'
第3个回答 2017-08-01
SELECT *
FROM (SELECT TO_DATE('20090605', 'yyyymmdd') + LEVEL - 1 AS EVERYDAY
FROM DUAL
CONNECT BY LEVEL <= (TO_DATE('20090608', 'yyyymmdd') -
TO_DATE('20090605', 'yyyymmdd') + 1));
第4个回答 2013-07-20
SELECT TO_DATE('2007/02/26' , 'yyyy/mm/dd ' ) +LEVEL - 1
FROM DUAL
CONNECT BY LEVEL <=
TRUNC(TO_DATE('2007/03/21', 'yyyy/mm/dd') -
TO_DATE('2007/02/26', 'yyyy/mm/dd')) + 1 2007/2/26
2007/2/27
2007/2/28
2007/3/1
2007/3/2
2007/3/3
2007/3/4
2007/3/5
2007/3/6
2007/3/7
2007/3/8
2007/3/9
2007/3/10
2007/3/11
2007/3/12
2007/3/13
2007/3/14
2007/3/15
2007/3/16
2007/3/17
2007/3/18
2007/3/19
2007/3/20
2007/3/21本回答被网友采纳
第5个回答 2013-07-20
select time from table_name where time>='2009-06-05' and time<='2009-06-08'