错误代码:1582 Incorrect parameter count in the call to

页面导航:首页 > 数据库 > DB2 > 错误代码:1582 Incorrect parameter count in the call to

错误代码:1582 Incorrect parameter count in the call to

来源: 作者: 时间:2016-01-23 11:15 【

1 错误描述1 queries executed, 0 success, 1 errors, 0 warnings查询:SELECT t `name`, DATE_FORMAT(str_to_date( 2015 ), %Y ) as statisDate, ROUND(IFNULL(SUM(t `amount`), 0

1. 错误描述

1 queries executed, 0 success, 1 errors, 0 warnings

查询:SELECT t.`name`, DATE_FORMAT(str_to_date('2015'), '%Y') as statisDate, ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS ...

错误代码: 1582
Incorrect parameter count in the call to native function 'str_to_date'

执行耗时   : 0 sec
传送时间   : 0 sec
总耗时      : 0 sec

2. 错误原因

SELECT 
  t.`name`,
  DATE_FORMAT(STR_TO_DATE('2015'), '%Y') AS statisDate,
  ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amount
FROM
  t_stu_info t 
WHERE 1 = 1 
  AND DATE_FORMAT(t.statisDate, '%Y') = '2015' 
UNION
ALL 
SELECT 
  t.`name`,
  DATE_FORMAT(STR_TO_DATE('2014'), '%Y') AS statisDate,
  ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amount
FROM
  t_stu_info t 
WHERE 1 = 1 
  AND DATE_FORMAT(t.statisDate, '%Y') = '2014'

MySQL内置函数str_to_date的格式是:str_to_date(字符串,日期格式);
在这个查询SQL中却是str_to_date(字符串),导致报错

3. 解决办法

修改查询SQL语句

SELECT 
  t.`name`,
  DATE_FORMAT(STR_TO_DATE('2015','%Y'), '%Y') AS statisDate,
  ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amount
FROM
  t_stu_info t 
WHERE 1 = 1 
  AND DATE_FORMAT(t.statisDate, '%Y') = '2015' 
UNION
ALL 
SELECT 
  t.`name`,
  DATE_FORMAT(STR_TO_DATE('2014','%Y'), '%Y') AS statisDate,
  ROUND(IFNULL(SUM(t.`amount`), 0), 3) AS amount
FROM
  t_stu_info t 
WHERE 1 = 1 
  AND DATE_FORMAT(t.statisDate, '%Y') = '2014'
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<