WITH sample AS (SELECT CAST('1614634859.2343071' AS float64) AS last_opened_time),
cast_to_int AS (
SELECT CAST(last_opened_time AS int64) AS last_opened_at FROM sample)
SELECT TIMESTAMP_SECONDS(last_opened_at) AS last_opened_at FROM cast_to_int;