More than 1 year has passed since last update.
何したかったのか
1秒未満の時刻をログにのこしソートしたかった。
syslogフォーマットだと1秒以下が記録されないので、雑にunixtimeをstringで送っておいた。
TIMESTAMP_ADD(TIMESTAMP_MILLIS(CAST(ROUND( CAST(unixtime as float64 ),3) * 1000 AS int64)),INTERVAL 9 HOUR) as JST
注意点
- 時間はJSTだけど、表示はUTCになる
- standard sql
Special thx @satoruxx
Why not register and get more from Qiita?
- We will deliver articles that match you
By following users and tags, you can catch up information on technical fields that you are interested in as a whole
- you can read useful information later efficiently
By "stocking" the articles you like, you can search right away
Sign upLogin