Skip to main content

"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" --> this gives me all the timestamps

timestamp"EventLog_ACME_TeachingCase_csv"."TIMESTAMP" LIKE {t '00:00:00'} --> things like this do not work

 

Thanks a lot!

 

Greetings,

Ronja

 

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

 

Capture 

You can also filter by just removing CASE WHEN parts.

Capture2Other 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

Reply


Terms & ConditionsCookie settings