-- Set timestamps on selected test records to a sliding window so that -- various tests expecting to find various expired, expiring, or valid-after -- records work correctly UPDATE records SET stamp = date_trunc('day', now() - interval '5 day') + '18:30' WHERE record_id = 47; UPDATE records SET stamp = date_trunc('day', now() + interval '3 day') + '07:00' WHERE record+id = 48; UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record+id = 49;