select * from table where trunc(bu_date)>=TO_DATE('2004-11-10','YYYY-MM-DD') and trunc(bu_date)<=TO_DATE('2004-11-10','YYYY-MM-DD') order by bu_date desc;orselect * from table where bu_date>=TO_DATE('2004-11-10','YYYY-MM-DD') and bu_date<=TO_DATE('2004-11-11','YYYY-MM-DD') order by bu_date desc;
解决方案 »
- 在oracle的存储过程里面执行sql
- 求助SQL语句
- 请教个数据库查询问题
- ORA-00600: 内部错误代码,参数: [kghGetHpSz1], [0x7E828050], [], [], [], [], [], []
- SQL查询,难倒我了,谁能帮帮忙,谢了
- 急!建了一个复杂点的视图,查出的数据与where子句中的条件发生矛盾!
- ORA-00918: 未明确定义列
- ORACLE里怎样调用自己写好的函数?
- 如何在PL/SQL数据库中将字符型数据转换成数字型,急!!!!!!!1
- 100分的问题 求forms开发的电子书籍
- 怎么样Select 到一个数据列表,然后在下面的Select 语句中使用In (上次检索到的记录列表)
- 散分,imp问题,急!
那么如下即可,
SQL> select * from aa;MYDATE
---------
11-NOV-04
11-NOV-04SQL> select * from aa where to_char(mydate,'yyyy-mm-dd')='2004-11-11';MYDATE
---------
11-NOV-04
11-NOV-04SQL> desc aa
Name Null? Type
----------------------------------------- -------- ----------------------
MYDATE DATE
select * from table where bu_date like TO_DATE('2004-11-10','YYYY-MM-DD') order by bu_date desc";
或者转为字符串比较
select * from table where to_char(bu_date,'yyyy-mm-dd') = '2004-11-10' order by bu_date desc";
select * from table where trunc(bu_date,'dd')>=TO_DATE('2004-11-10','YYYY-MM-DD') and trunc(bu_date,'dd')<=TO_DATE('2004-11-10','YYYY-MM-DD') order by bu_date desc";trunc的作用是把日期类型的精确到天,不计后面的时分秒,当然,精确度可由你自己决定.
select * from table where to_char(bu_date,'yyyy-mm-dd')>='2004-11-10' and to_char(bu_date,'yyyy-mm-dd')<='2004-11-10' order by bu_date desc