SELECT
*
FROM
`テーブルパス` FOR SYSTEM_TIME AS OF
TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY)
INTERVAL 6 DAY の 6 を所望の日にすることで遡る日を指定可能
More than 1 year has passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme