ORA-01843:无效月份to_date(substr(:processdate,1,11),'mm / dd / YYYY') [英] ORA-01843: not a valid month to_date(substr(:processdate, 1, 11), 'mm/dd/YYYY')
问题描述
大家好,
我的oracle表中的
我有一个名为:
processdate
数据类型日期的列。< br $>
表中的处理日期值为:
6/5/2018
尝试运行以下查询获取异常。
SELECT to_date(substr(:processdate,1,10), 'mm / dd / YYYY')FROM table
如果我输入processdate:
6/5/2018
它抛出异常,如
A-01843:无效月份
请指导我这个查询有什么问题。
非常感谢。
我尝试过:
< pre> SELECT to_date(substr(:processdate,1,10) ),'mm / dd / YYYY')FROM table
如果我输入processdate:
6/5 / 2018
它抛出异常,如
A-01843:无效月
Hi all, datatype date. it was throwing exception like it was throwing exception like 这篇关于ORA-01843:无效月份to_date(substr(:processdate,1,11),'mm / dd / YYYY')的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋! processdate
字段是日期时间数据类型,并且您想要拒绝/删除时间部分,则必须使用TRUNC [ ^ ]功能。
in my oracle table I have a column called :processdate
Process date value in table is :6/5/2018
trying to run the below query getting exception .
SELECT to_date(substr(:processdate, 1,10), 'mm/dd/YYYY') FROM table
if I enter processdate :6/5/2018
A-01843: not a valid month
please guide me what is wrong with this query.
Thanks inadvance.
What I have tried:
<pre>SELECT to_date(substr(:processdate, 1,10), 'mm/dd/YYYY') FROM table
if I enter processdate :6/5/2018
A-01843: not a valid month
Assuming that a
processdate
field is a datetime data type and you want to reject/remove time part, you have to use TRUNC[^] function.