The SysQueryRangeUtil includes some great tools for use in batch jobs and tiles to dynamically look for records that fall within certain date intervals relative to todays date (all works completed today/works that have been in progress for more than one day, sales order picked but not delivered in at least a day etc. etc.
However the options are limited to full days.. It would be wonderful to also have options that could look at hours/minutes on date/time fields to forexample say everything that has been updated in the last two hours, automatically update everything that has not been modified in at least 3 hours etc.