No such function date_format in ROQL
Summary
No such function date_format in ROQLContent
Below ROQL sentences says 'No such function date_format". I don't want to consider seconds.
SELECT IncidentID,ID,updatedtime FROM CO.History
where IncidentID is not null
group by incidentID, date_format(updatedtime, 'YYYY-MMDD HH:MI')
having count(*) > 1
How to re-write this ROQL without error?
Tagged:
0