You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

No such function date_format in ROQL

Question
25
Views
0
Comments
edited Nov 24, 2020 9:28AM in Customer Portal

Summary

No such function date_format in ROQL

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!