Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
来源:互联网 发布:微博个性域名怎么修改 编辑:程序博客网 时间:2024/05/21 10:20
解决:Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
今天在写update日期格式的时候,老是报一个错。
报错:
Oracle 异常 ORA-01861: literal does not match format string(字符串格式不匹配)
原因:
如果直接按照字符串方式,或者,直接使用'2013-2-26 11:07:25',没有指定日期格式,就会报错
正确方法:
必须指定日期格式,如下:
to_date('2013-2-26 11:07:25' , 'yyyy-mm-dd hh24:mi:ss')
0 0
- 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: 文字与格式字符串不匹配
- JSValidation Chrome适配修改
- Installanywhere 打包mysql tomcat jdk
- 初识Spring Boot框架
- jboss集群session复制原理
- 孤独与寂寞的区别
- Oracle异常ORA-01861:literal does not match format string(字符串格式不匹配)
- select a method for export 各项的意思
- Matlab插值
- Android闹钟设置的解决方案
- 去掉状态栏
- freeswitch获取SIP客户端IP地址
- test2
- USB linux NCM usbnet驱动详解
- Hadoop-RPC应用demo