ORA-01830错误

最新推荐文章于 2019-02-27 16:48:00 发布

SpallationMetamorph

最新推荐文章于 2019-02-27 16:48:00 发布

阅读量349

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库

本文链接：https://blog.youkuaiyun.com/SpallationMetamorph/article/details/83693275

数据库专栏收录该内容

5 篇文章

订阅专栏

遇到这个错：ORA-01830: 日期格式图片在转换整个输入字符串之前结束

wrong:

select *
from region_top rt, region r
where rt.region_id = r.region_id
and rt.stat_time >= to_date('2010-7-27 12:44:01', 'yyyy-mm-dd HH24:MI')
and rt.stat_time <= to_date('2010-7-28 10:59:59', 'yyyy-mm-dd HH24:MI')

right:

select *
from region_top rt, region r
where rt.region_id = r.region_id
   and rt.stat_time >= to_date('2010-7-27 12:44', 'yyyy-mm-dd HH24:MI')
   and rt.stat_time <= to_date('2010-7-28 10:59', 'yyyy-mm-dd HH24:MI')

启示：
SELECT TO_DATE('2007/04/01 13:30:01','YYYY-MM-DD') A FROM dual;
SELECT TO_DATE(SUBSTR('2007/04/01 13:30:01',1,10),'YYYY/MM/DD') B FROM dual;
SELECT SUBSTR('2007/04/01 13:30:01',1,10) FROM DUAL;