\set days random(1, 2550)
SELECT * FROM magasin.commandes WHERE date_commande > now() - interval '7 years' + interval '1 day' * :days;
