INFO - toLookUp() - : sql = select to_char(max(begintime),'yyyy-mm-dd hh24:mi:ss')||'.999' begintime from dsn_client
INFO - 读取dbcfg.ini文件中...
INFO - 装载和注册所有JDBC驱动程序...
com.mysql.jdbc.Driver
INFO - 根据指定属性创建连接池实例...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION duoxinnew.to_char does not existINFO - toLookUp() - : sql = select max(to_number(user_id)) user_id from sys_user where sign in(3,0)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION duoxinnew.to_number does not exist2013-3-12 10:48:58定时器RUN
2013-3-12 10:48:58定时器RUN上面是报出的错误信息。
duoxinnew (数据库)
dsn_client(表)在运行java项目的时出现的错误,急! sosmysqljdbc
INFO - 读取dbcfg.ini文件中...
INFO - 装载和注册所有JDBC驱动程序...
com.mysql.jdbc.Driver
INFO - 根据指定属性创建连接池实例...
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION duoxinnew.to_char does not existINFO - toLookUp() - : sql = select max(to_number(user_id)) user_id from sys_user where sign in(3,0)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION duoxinnew.to_number does not exist2013-3-12 10:48:58定时器RUN
2013-3-12 10:48:58定时器RUN上面是报出的错误信息。
duoxinnew (数据库)
dsn_client(表)在运行java项目的时出现的错误,急! sosmysqljdbc
show function status;
看一下?
DATE_FORMAT(max(begintime),'%Y-%m-%d &H:&i:%s')
自定义函数to_char()是有的。
用DATE_FORMAT也可以设置格式
显示:
Query : show function to_char("")
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to_char("")' at line 1
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000不知道我这么做对不对。如果to_char()不可用怎么办?
SHOW FUNCTION STATUS to_char
Query : SHOW FUNCTION CODE to_char
Error Code : 1289
The 'SHOW PROCEDURE|FUNCTION CODE' feature is disabled; you need MySQL built with '--with-debug' to have it working
内容显示功能被禁用后面的执行结果是显示语法错误,是不是可以确定是用的是oracle开发的怎么解决这样的错误?
DATE_FORMAT(max(begintime),'%Y-%m-%d %H:%i:%s')
即可
DATE_FORMAT(max(begintime),'%Y-%m-%d %H:%i:%s')
即可to_char /to_number:MYSQL没有,ORACLE有