Compare UNIX vs EPOC timestamps

[edipseamm]

Hey Guys

I'm trying to find the best way to compare UNIX vs EPOC timestamps for monitoring the last communication.

I was looking for a function to make the EPOC only significant to 10 digits, but I am struggling with this.

Any ideas?



TIA

[edipseamm]

I tried to extract the extra digits via command recognition s\s10 command, then subtract them from the original value to give me the same 10 digits to compare also but end up with extra 0s now.


Also you can see '000' being added at the start of the command recognition but then being dropped on the Lv output.

[edipseamm]

I tried also to use a memory flag to pass the value in then use the output v.10 for example but this did not give me the result I was looking for

[duncan]

ive used the zigbee2mqtt timestamp (input via a virtual text input) /1000 to remove the 000 then compare to the inbuilt unix timestamp

[Jan W.]

A division by 1000 might be enough as duncan said. You may also use an "INT" function in a formula function block (after the division) to remove the fraction if you need to compare exact values (equal) instead of greater or smaller.

[edipseamm]

Ahh yeah that worked. When I had tested this before i had not noticed the decimal point (.)

Example for others. Monitoring if the time is greater than 1 day (86400)

[edipseamm]

A division by 1000 might be enough as duncan said. You may also use an "INT" function in a formula function block (after the division) to remove the fraction if you need to compare exact values (equal) instead of greater or smaller.

Ahh yes the INT is what I needed. A simple INT(I1-I2) worked for me

[edipseamm]

And to simply further: INT(I1-(I2/1000))

Thanks for these pointers