SELECT -- 日付を表示 DATE(TIMESTAMP('2020-10-20 00:00:00'), 'Asia/Tokyo') AS Date -- 月曜日の日付を表示 , DATE_TRUNC(DATE(TIMESTAMP('2020-10-20 00:00:00'), 'Asia/Tokyo'), WEEK(MONDAY)) AS Week_mondy -- 対象月を表示 , DATE_TRUNC(DATE(TIMESTAMP('2020-10-20 00:00:00'), 'Asia/Tokyo'), MONTH) AS month -- 対象年を表示 , DATE_TRUNC(DATE(TIMESTAMP('2020-10-20 00:00:00'), 'Asia/Tokyo'), YEAR) AS year
◆実行結果
![](https://apl-py.com/blog/wp-content/uploads/2021/08/2ec0488e32d0d2603d372f5834dc256d.png)