Convert an interval (timestamp) to an integer

Can you convert an interval (timestamp) to an integer or number in Tulip?

1 Like

Good suggestion! It is not currently possible to convert a value with data type “interval” to any other data type.

Hello Sathya, Wei,

I’m still loooking on how to covert timestamp to integer as I would like to make calculation (such as OEE). Did you find some workarounds ?

Warm regards,
Patxi

Nevermind Texttonumber() is working just fine !

Great to hear @pte!! That function works great for what you’re trying to achieve. Were you able to set up the triggers to calculate OEE (and others) correctly??

Yes it’s ok thanks Gio :slight_smile:

1 Like

Great @pte. You should share what you built on https://community.tulip.co/c/show-and-tell/9 :link: when you get the chance!!