Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
来源:互联网 发布:新版知乎怎么提问 编辑:程序博客网 时间:2024/05/01 03:07
Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
如果直接按照字符串方式,或者,直接使用'2007-12-28 10:07:24',没有指定日期格式,就会报错:ORA-01861: 文字与格式字符串不匹配
必须指定日期格式
报错
SELECT D261 as ename,GENTIME,D267 FROM UNITE.UPR_C2_NE_VENDOR T
where T.GENTIME<'2009-03-18 17:03:00'
正确
SELECT D261 as ename,GENTIME,D267 FROM UNITE.UPR_C2_NE_VENDOR T
where T.GENTIME<to_date('2009-03-18 17:03:00' , 'yyyy-mm-dd hh24:mi:ss')
- Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- 解决:Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- 解决Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
- Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
- oracle学习笔记【 ORA-01861: literal does not match format string(字符串格式不匹配)】
- Oracle异常ORA-01861: literal does not match format string。
- Oracle 异常 ORA-01861: literal does not match format string
- ORA-01861: literal does not match FORMat string 错误原因
- ORA-01861: literal does not match format string 错误!
- ORA-01861: literal does not match format string
- 关于ORA-01861: literal does not match format string
- Oracle 异常 ORA-01861: literal does not match form
- 关于时间比较,ORA-01861: literal does not match format string
- literal does not match format string 解决办法
- literal does not match format string
- Weblogic&oracle 异常 ORA-01861: 文字与格式字符串不匹配
- SQL-Oracle异常--java.sql.SQLDataException: ORA-01861: 文字与格式字符串不匹配
- OpenMP Tutorial学习笔记(2)OpenMP编程模型
- JS拖曳翻页
- android 调用系统的卸载程序
- float 原理,看懂这一篇,你就懂了!!!
- 通信格式的约定(两种方式)
- Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
- n阶方格的走法
- Hibernate复习笔记(一)
- 问号传值价码
- (1)巩固一下C语言基础知识,谁动手,谁收获
- 俺遭遇的“邮寄包裹骗局”
- Wince驱动中的_try,_except涵义分析
- android push
- (2)巩固一下C语言基础知识,谁动手,谁收获