We don’t currently have a built-in function for Unix Epoc time.  We added a “uptime” to the data model.  In that case it is “relative” time.  We then have a function to turn the “relative seconds” to Years, Days, Hours, Minutes.

Let me see what that would look like as a user function.

-Tyson

Oddly extractJson seemed to treat it as a Float. It didn’t like it as type Number so I changed to Float and it passed but not with correct result.   lastUpdateMicros: Float vs. lastUpdateMicros: Number worked.

@dakotaglory Apparently this is going to get really easy in release 24.9.  That should be available by the end of this week for Saas.  On-prem it will be next week.

Hello @dakotaglory.

fwd.app was upgraded to 24.9 late on Wednesday.  Now you can write

>{
  Date: date("1970-01-01") + seconds(1725899407),
  Timestamp: timestamp("1970-01-01T00:00:00Z") + seconds(1725899407),
}]

which gives

That is fantastic news!  Thank you!