SELECT *
FROM some_table
WHERE update_datetime
BETWEEN SYSDATE - INTERVAL '1' MINUTE * :interval
AND SYSDATE
というふうに書けばよいそうです。
とてもトリッキー?
More than 5 years have passed since last update.
SELECT *
FROM some_table
WHERE update_datetime
BETWEEN SYSDATE - INTERVAL '1' MINUTE * :interval
AND SYSDATE
というふうに書けばよいそうです。
とてもトリッキー?
Register as a new user and use Qiita more conveniently