ORA-01810: format code appears twice
来源:互联网 发布:淘宝商城业务流程图 编辑:程序博客网 时间:2024/06/06 10:54
Oralce中的to_date()函数用于将字符串转换为日期对象,具体使用格式为:
to_date( string, [ format_mask ] , [ nls_language ] ) <pre></pre>
string1
要转换的字符串.format_mask 可选项,日期转换格式.
nls_language 可选项. 指定用于转换字符串的nls language.
[问题]
ORA-01810: format code appears twice
可能是像Java那样指定日期格式,比如:
to_date('2006-06-01 18:00:00' 'yyyy-mm-dd hh:MM:ss')
而在Oracle中的日期格式是不区分大小写的,所以 mm 出现了两次。
正确的写法是:
to_date('2006-06-01 18:00:00' 'yyyy-mm-dd hh:mi:ss')
- ORA-01810: format code appears twice
- ORA-01810: format code appears twice
- ORA-01810: format code appears twice
- ORA-01810: format code appears twice
- format code appears twice
- format code appears twice 解决方法
- 20170401 oracle format code appears twice
- Given an array of integers, every element appears twice except for one. Find that single one.
- Given an array of integers, every element appears twice except for one. Find that single one.
- Given an array of integers, every element appears twice except for one. Find that single one.
- Given an array of integers, every element appears twice except for one. Find that single one.
- JEDI Code Format
- eclipse code format设置
- ace editor format code
- vs2010 format source code
- code online format
- Linux code format (代码格式化)
- linux code format tool indent
- 06-windowsPhone常用控件----按钮累加器和超链接按钮
- 链表的实现
- oracle proc
- myeclipse 8.5 破解
- ORA-01102的解决
- ORA-01810: format code appears twice
- 2.你有三个碗:分别是8,5,3公升容量。你能用最少的次数倒出两个四升水吗?
- Android 开机画面过程
- linux内核源码阅读之facebook硬盘加速flashcache之四
- 新站和老站在搜索引擎优化方面的差异
- oracle 判断字段是否为是数字 regexp_like用法 正则表达式
- shell循环,判断介绍,以及实例
- 3.你有三个碗:分别是7,4,3升容量。只有7升那个是满的。用最少次数倒出分别是2,2,和3升水。
- wince修改程序内存和存储内存