SELECT
*
FROM
`テーブルパス` FOR SYSTEM_TIME AS OF
TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY)
INTERVAL 6 DAY
の 6
を所望の日にすることで遡る日を指定可能
SELECT
*
FROM
`テーブルパス` FOR SYSTEM_TIME AS OF
TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY)
INTERVAL 6 DAY
の 6
を所望の日にすることで遡る日を指定可能
Register as a new user and use Qiita more conveniently