Try this... but alter the "<1" to fit your need... maybe need <2 etc...

select * from adsm.backups where (node_name='YOUR_NODE' and
cast((current_timestamp-backup_date)day as decimal(18,0))<1)