How do I subtract created (unix timestamp) from current date and express the difference in "hrs"

[Sumanta_Basu]

Writing an API in coddles API service console to generate user “Comment” and “Timestamp” when the comment was made. As the underlying table maintains the “Created” filed in unixtimestamp, I want to subtract this field from Current time (Now) and capture the difference in “Hrs” to indicate how old the comment was made.

Please help me, to proceed with this.

[sergey.kuk (Sergii Kukurudziak)]

Hello @Sumanta_Basu

you can do it in the following way:

The selected property NOW()-created as dbAge will contain the age of the record

[Sumanta_Basu]

Hi @sergey.kuk , many thanks

Regards
Sumanta