ORA-01858: a non-numeric character was,to_date問題

最新推荐文章于 2021-04-14 05:45:23 发布

最新推荐文章于 2021-04-14 05:45:23 发布 · 2.4k 阅读

标签

#SQL #Java

收录于

java异常专栏收录该内容

40 篇文章

订阅专栏

本文介绍了一个常见的数据库操作错误ORA-01858：在期望数值处发现非数字字符，并给出了具体的解决方案。该问题通常发生在尝试将日期作为字符串传递给数据库时，正确的做法应当使用 setDate 方法来传递日期类型。

ORA-01858: a non-numeric character was found where a numeric was expected

这个问题是由于

Date dateCreated = startBookForm.getDateCreated();//录入日期

String dateCreatedStr = "to_date('"+dateCreated+"','yyyy-mm-dd HH24:MI:SS')";



pstmt.setString(5, dateCreatedstr);//传递日期类型的时候用了String

改成下面这样就好了

Date dateCreated = startBookForm.getDateCreated();//录入日期



pstmt.setDate(5, dateCreated);//传递日期类型时需要setDate

黑色头发 http://heisetoufa.iteye.com

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

limon758

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

做orcle报表出现的问题（本文章用于问题记录）

qq_42007608的博客

04-09

472

ORA-00904: "LOCCNTR": invalid identifier 先分组再求百分比 ORA-00923: FROM keyword not found where expected NVL函数与decode函数查询月份多少天

参与评论您还未登录，请先登录后发表或查看评论

ORA-01858: a non-numeric character was found where a numeric was expected

weixin_30859423的博客

11-06

1724

程序操作Oracle数据库时，出现“ORA-01858: a non-numeric character was found where a numeric was expected”错误。原因是语句中包含“lurudate = TO_DATE('197001ull','yyyymmddhh24mi')”，里面的时间格式不正确。以后写程序时一定要加强对数据合法性的校验。转载于:https...

Springmvc UPDATE 数据时 ORA-01858:a non-numeric character was found where a numeric was expected

liaoze的博客

07-10

2万+

ORA-01858:a non-numeric character was found where a numeric was expected 异常。我的代码：主要是绑定变量带出来的问题。出错原因是：preparedstatement在执行的时候不能把带有to_date的参数的串替换为sql中的问号,主要是to_date函数替换不了，解决办法是将to_date函数先放到sql语句中，然后替

oracle存在非数字字符,oracle – 获取错误 – ORA-01858：找到了一个非数字字符,其中包含数字...

weixin_36313293的博客

04-10

2220

我在下面的sql中收到错误：ORA-01858: a non-numeric character was found where a numeric was expectedSELECT c.contract_num,CASEWHEN ( MAX (TO_CHAR (TO_DATE (c.event_dt, 'YYYY-MM-DD'), 'MMDD'))- MIN (TO_CHAR (T...

oracle ora 01850,Oracle SQL to_date & to_timestamp ORA-01858: a non-numeric character was found wher...

weixin_29061531的博客

04-11

1046

问题I have a small bit of code:CodeSELECT to_date(it.DSTAMP, 'DD/MM/YYYY') AS "Date", to_timestamp(it.DSTAMP, 'HH24:MI:SS') AS TimeFROM itable itErrorsORA-01858: a non-numeric character was found where ...

Springmvc UPDATE 数据时 ORA-01858:a non-numeric character was found where a numeric was expected...

10-08

800

oracle只取数字,oracle – 获取错误 – ORA-01858：找到了一个非数字字符,其中包含数字...

weixin_42105816的博客

04-02

953

XML-RPC规范(半中文版)

蜗牛档案室

12-03

1925

Tue, Jun 15, 1999; by Dave Winer. （翻译:滴水最后修改时间:2005-3-15 后续完善）更新 6/30/03 DW 更新 10/16/99 DW 更新 1/21/99 DW 本规范说明的XML-RPC协议实现UserLand Frontier 5.1。关于非技术性说明，请访问XML-RPC for Newbies。文档提供了实现X

ORA-01858

方块石

04-28

914

ORA-01858: a non-numeric character was found where a numeric was expected ORA-01858: a non-numeric character was found where a numeric was expected 这个问题是由于 Java代码 Date dateCreated =...

解决：Oracle 异常 ORA-01861& ORA-01858 问题

知跬步，至千里

04-10

1万+

最近在调试SQL时遇到如下两个Oracle报错： ORA-01858: a non-numeric character was found where a numeric was expected ORA-01861: literal does not match format string 今天把其记录下来，以便增加记忆，和日后查阅。原因：在SQL中有使用TO_DATE函数进行日期转换，...

oracle错误代码 1858,ORA-1858: a non-numeric character was found where a numeric was expected — oracle-te...

weixin_42342010的博客

04-03

1159

I do not know how to use MERGE and did not find much information on it. But I looked into modifying it and once again, it compiles in this case but when I run it using the debugger, no code is inserte...

我遇到的Oracle下出错提示及解决办法

qqp_528的专栏

04-07

5520

1、错误提示：ORA-01036: ####### 出错情况：在python中用sqlalchemy操作数据库，数据库名TBPREFERENTIALWEEK，操作字段名USERACCOUNTS。原因：由于操作字段名过长，使得组合后的字段名TBPREFERENTIALWEEK_USERACCOUNTS，超过31个字符长度，导至操作字段名出错。解决方法：在sq

oracle中按日期查询报错问题和merge into语句的

zhunode的探索

11-13

767

1 ORA-01858 ：在要求输入数字处找到非数字字符这两个一起记述的主要原因是需要这样做，且报错了。。。我先贴出我的sql语句来：出错原因是：preparedstatement在执行的时候不能把红框内的串替换为sql中的问号,主要是to_date函数替换不了，解决办法是将to_date函数先放到sql语句中，然后替换后面的变量，就不报这个错误了。这句是直接摘抄人家的：ORA...

hibernate/jpa/PreparedStatement 添加动态 to_date 时间参数报错：ORA-01858 在要求输入数字处找到非数字字符

tfish的专栏

09-03

1963

用 hibernate 的 createNativeQuery 添加 to_date 时间参数报错：ORA-01858 在要求输入数字处找到非数字字符。一开始把 to_date 写到了设置 :参数那一行，就会报错 ORA-01858 在要求输入数字处找到非数字字符。将 to_date 写到动态 sql 语句那一行，就不报错了。贴出 hibernate 正确设置 to_da...

ORA-01858 ：在要求输入数字处找到非数字字符