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

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.

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

Hi @sergey.kuk , many thanks :slight_smile: