SQLDATE 函数 SQL 错误 [936] [42000]：ORA-00936：缺少表达式¶

Question

SELECT DATE(eoa.DATETIME) AS Date_OF_Alert,
COUNT(*) AS Num
FROM   ECMS_ONLINE_ALERTS eoa
GROUP BY DATE(eoa.DATETIME)
ORDER BY eoa.DATETIME 

这是我的sql函数，我得到了类似的错误

SQL错误[936][42000]：ORA-00936:缺少表达式¶

如何解决

Answer 1

请参阅：Oracle SQL"从DATETIME字段中选择日期"；

用途：

SELECT TRUNC(eoa.DATETIME) AS Date_OF_Alert,
COUNT(*) AS Num
FROM   ECMS_ONLINE_ALERTS eoa
GROUP BY TRUNC(eoa.DATETIME)
ORDER BY TRUNC(eoa.DATETIME)