0
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

this my sql function i am getting error like

SQL Error [936] [42000]: ORA-00936: missing expression¶

how to resolve it

RBarryYoung
  • 55,398
  • 14
  • 96
  • 137
Sivamohan Ahagaash
  • 23
  • 3
  • 2
    Hint: DATETIME is a very poor choice for a column name as it's a reserved word in most RDBMS – Mitch Wheat Apr 06 '22 at 10:48
  • Does this answer your question? [Oracle SQL "SELECT DATE from DATETIME field "](https://stackoverflow.com/questions/29004960/oracle-sql-select-date-from-datetime-field) – nbk Apr 06 '22 at 11:45

1 Answers1

0

see: Oracle SQL "SELECT DATE from DATETIME field "

use:

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)
Luuk
  • 12,245
  • 5
  • 22
  • 33