How about: select node_name,filespace_name,backup_end from filespaces where backup_end<current_timestamp-24 hours