Anyone know how to get timestamp as UNIX time in suiteql?

This does it as ISO8601 timestamps,

SELECT to_char(sys_extract_utc(SYSTIMESTAMP), 'YYYY-MM-DD"T"HH24:MI:SS"Z"') AS current_time
FROM DUAL

UNIX timestamp would be more complicated, you'd need to use the

TO_DATE

function with a timezone (there's no documented way to do it), and then calculate the difference