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

标签: MySQL+字符串
2942人阅读 评论(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'
1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:4013035次
    • 积分:60186
    • 等级:
    • 排名:第39名
    • 原创:1897篇
    • 转载:76篇
    • 译文:3篇
    • 评论:1067条
    百度技术栏目
    网易博客
    新浪博客
    博客专栏
    Linux

    文章:47篇

    阅读:54271
    dojo

    文章:10篇

    阅读:27359
    Flex

    文章:13篇

    阅读:26380
    FusionCharts

    文章:14篇

    阅读:66628
    文章分类
    最新评论