Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
-- 事前にDECLAREで変数定義
DECLARE target_date DATE;
-- 変数に値を設定
SET target_date = DATE('2021-01-01');
SELECT
target_date
, DATE_TRUNC(target_date, WEEK(MONDAY)) AS target_monday
, DATE_TRUNC(target_date, WEEK(TUESDAY)) AS target_tuesday
, DATE_TRUNC(target_date, WEEK(WEDNESDAY)) AS target_wednesday
, DATE_TRUNC(target_date, WEEK(THURSDAY)) AS target_thursday
, DATE_TRUNC(target_date, WEEK(FRIDAY)) AS target_friday
, DATE_TRUNC(target_date, WEEK(SATURDAY)) AS target_saturday
, DATE_TRUNC(target_date, WEEK(SUNDAY)) AS target_sunday
-- 事前にDECLAREで変数定義 DECLARE target_date DATE; -- 変数に値を設定 SET target_date = DATE('2021-01-01'); SELECT target_date , DATE_TRUNC(target_date, WEEK(MONDAY)) AS target_monday , DATE_TRUNC(target_date, WEEK(TUESDAY)) AS target_tuesday , DATE_TRUNC(target_date, WEEK(WEDNESDAY)) AS target_wednesday , DATE_TRUNC(target_date, WEEK(THURSDAY)) AS target_thursday , DATE_TRUNC(target_date, WEEK(FRIDAY)) AS target_friday , DATE_TRUNC(target_date, WEEK(SATURDAY)) AS target_saturday , DATE_TRUNC(target_date, WEEK(SUNDAY)) AS target_sunday
-- 事前にDECLAREで変数定義
DECLARE target_date DATE;
-- 変数に値を設定
SET target_date = DATE('2021-01-01');

SELECT
  target_date
  , DATE_TRUNC(target_date, WEEK(MONDAY)) AS target_monday
  , DATE_TRUNC(target_date, WEEK(TUESDAY)) AS target_tuesday
  , DATE_TRUNC(target_date, WEEK(WEDNESDAY)) AS target_wednesday
  , DATE_TRUNC(target_date, WEEK(THURSDAY)) AS target_thursday
  , DATE_TRUNC(target_date, WEEK(FRIDAY)) AS target_friday
  , DATE_TRUNC(target_date, WEEK(SATURDAY)) AS target_saturday
  , DATE_TRUNC(target_date, WEEK(SUNDAY)) AS target_sunday

◆実行結果


この記事が気に入ったら『目黒で働く分析担当の作業メモ』ご支援をお願いします!

※OFUSEに飛びます


おすすめの記事