17,086
社区成员
发帖
与我相关
我的任务
分享
Selece * from table
where date>=to_date('2010-08-11 00:00:00','yyyy-mm-dd hh24:mi:ss')
and date<=to_date('2010-08-11 23:59:59','yyyy-mm-dd hh24:mi:ss')
SQL> select trunc(sysdate) from dual;
TRUNC(SYSDATE)
--------------
2010-8-11
SQL> select trunc(sysdate+1)-1/24/60/60 from dual;
TRUNC(SYSDATE+1)-1/24/60/60
---------------------------
2010-8-11 23:59:59
SQL>