BigQuery関数 | unixtimeをDATETIMEに変換する｜とくきちのゆるログ

方法 unixtime（秒）→ DATETIME WITH raw_data AS ( SELECT 1619531893 AS unixtime ) SELECT unixtime, -- TIMESTAMP_SECONDS関数を使う CAST(FORMAT_TIMESTAMP('%Y-%m-%d %H:%M:%S', TIMESTAMP_SECONDS(unixtime), 'Asia/Tokyo') as DATETIME) AS jst FROM raw_data 結果 unixtimejst unixtime（ミリ秒）→ DATETIME WITH raw_data AS ( SELECT 1619531893000 AS unixtime ) SELECT unixtime, -- TIMESTAMP_MILLIS関数を使う CAST(FORMAT_TIMESTAMP('%Y-