OracleÖвéѯ×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¿

ÔÚOracleÖУ¬ÎÒÏë²éϵͳʱ¼äÒ»ÌìµÄÊý¾Ý£¬Ê¹ÓÃÕâ¸öÓï¾ä
select * from tablename
where create_time>SYSDATE-1
and create_time <SYSDATE


ÎÒÏë²é×òÌì00£º00µ½½ñÌì00£º00µÄsqlÔõôд£¬
»òÕßÎÒÏë²éÇ°Ìì08£º00µ½½ñÌì08:00µÄsqlÔõôд£¬

µ±È»²»ÄÜд¾ßÌåʱ¼ä£¬ÒòΪÿ´ÎÎÒ¶¼²éÕâÖÖÊý¾Ý

---

select * from tablename
where create_time>= trunc(SYSDATE-1)
and create_time <trunc(SYSDATE )

---

select * from tablename
where create_time> trunc(SYSDATE-1)+ 8/24
and create_time < trunc(SYSDATE) + 8/24

---

select * from tablename
where create_time>to_date('20090103 00:00:00','yyyymmdd hh24:mi:ss')
and create_time <to_date(20090104 00:00:00','yyyymmdd hh24:mi:ss')

Ï붨ʱ²éѯ³öÊý¾Ý£¬×öÈÕÖ¾±¸·Ý»ò×öÆäËû´¦Àí£¬ÄǾÍд¸öjob
¶¨Ê±ÔËÐÐ

---

select * from tablename
where create_time>= trunc(SYSDATE-1)
and create_time <trunc(SYSDATE )

select * from tablename
where create_time> trunc(SYSDATE-1)+ 8/24
and create_time < trunc(SYSDATE) + 8/24
¶¥£¡

---

ÒýÓÃ

select * from tablename
where create_time>to_date('20090103 00:00:00','yyyymmdd hh24:mi:ss')
and create_time <to_date(20090104 00:00:00','yyyymmdd hh24:mi:ss')

Ï붨ʱ²éѯ³öÊý¾Ý£¬×öÈÕÖ¾±¸·Ý»ò×öÆäË