SQL查询不断提示: 00904。00000 - "%s:无效的标识符“
SQL查询不断提示: 00904。00000 - "%s:无效的标识符“
提问于 2019-11-27 15:10:45
SQL查询不断提示：
"ORA-00904: "DATE_FORMAT": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 11 Column: 110"运行查询时的消息
select AUX4 as "ID",COUNT(AUX4) AS "Fails number" FROM audits where TRSTATUS <> 'SUCCESS' and DATECREATED > UPPER(DATE_FORMAT(NOW()-INTERVAL '7' DAY,"%d-%b-%y")) GROUP BY AUX4 ORDER by "Fails number" desc;如果手动输入用于比较的日期，则工作完全正常，如
select AUX4,COUNT(AUX4) AS "Fails number" FROM audits where TRSTATUS <> 'SUCCESS' and DATECREATED > '25-NOV-2019' GROUP BY AUX4 ORDER by "Fails number" desc;回答 1
Stack Overflow用户
回答已采纳
发布于 2019-11-27 15:23:07
下面是您的oracle日期格式。将mysql NOW()替换为sysdate，将DATE_FORMAT替换为TO_CHAR。
select AUX4 as "ID"
,COUNT(AUX4) AS "Fails number"
FROM audits where TRSTATUS <> 'SUCCESS' and
DATECREATED > UPPER(TO_CHAR(SYSDATE-INTERVAL '7' DAY,'DD-MON-YYYY'))
GROUP BY AUX4 ORDER by "Fails number" desc;此link可能会帮助您将mysql查询转换为oracle。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59064848
复制相关文章
相似问题
腾讯云开发者
