-- 事前にDECLAREで変数定義 DECLARE timestamp_date TIMESTAMP; -- 変数に値を設定 SET timestamp_date = TIMESTAMP('2019-11-01 00:00:00'); SELECT SUBSTR(CAST(timestamp_date AS STRING), 1, 4) as y SUBSTR(CAST(timestamp_date AS STRING), 1, 7) as ym SUBSTR(CAST(timestamp_date AS STRING), 1, 10) as ymd
◆実行結果
![](https://apl-py.com/blog/wp-content/uploads/2021/08/20dbcdc8f9ec12b337a7e7a73bf584e6.png)