create table credit_card_transactions(transaction_time timestamp);
create table my_timer(id int primary key, t timestamp);
create view recent_transactions as
SELECT * FROM credit_card_transactions
WHERE transaction_time >= (SELECT DATE_SUB(t, INTERVAL 1 DAY) FROM my_timer);