[トレジャーデータ]PRESTOで日付を年や月に変換する

2021-07-08 2021-12-18

SELECT

target_date

, SUBSTR(target_date, 1, 4) AS y -- target_dateを年に変換

, SUBSTR(target_date, 1, 7) AS ym -- target_dateを年月に変換

, SUBSTR(target_date, 1, 10) AS ymd -- target_dateを年月日に変換

FROM

TABLE1

SELECT target_date , SUBSTR(target_date, 1, 4) AS y -- target_dateを年に変換 , SUBSTR(target_date, 1, 7) AS ym -- target_dateを年月に変換 , SUBSTR(target_date, 1, 10) AS ymd -- target_dateを年月日に変換 FROM TABLE1

SELECT 
  target_date
  , SUBSTR(target_date, 1, 4) AS y  -- target_dateを年に変換
  , SUBSTR(target_date, 1, 7) AS ym  -- target_dateを年月に変換
  , SUBSTR(target_date, 1, 10) AS ymd  -- target_dateを年月日に変換
FROM
  TABLE1