I would like to see all the activites where there is a noise in the timestamp with the values 00:00:00 as the time. What is the PQL for that?I tried things like and it didnt't work

Hello Ranja,

Quick and dirty idea is just to simply add hours + minutes + seconds and check if their sum is 0.

If it solves your problem, just mark answer as best.

CASE WHEN HOURS("_CEL_ACTIVITIES"."EVENTTIME") + MINUTES("_CEL_ACTIVITIES"."EVENTTIME") + SECONDS("_CEL_ACTIVITIES"."EVENTTIME") = 0 THEN 'Noise timestamp' ELSE 'Normal timestamp' END

You can also filter by just removing CASE WHEN parts.

Other way is to use {d} syntax, however it can be problematic because of the date part. When specific day matches - it seems to be working well.

CASE WHEN "_CEL_ACTIVITIES"."EVENTTIME" = {d '2020-09-30 00:00:00'} THEN 1 ELSE 0 END 

Best Regards,

Mateusz Dudek