what exactly are you filtering for? Why do you want to use time()?
COuld you explain a bit more about what you are looking for?
I want to be able to trigger a report for customers in a video store. If the time which has been recorded initially (in a rental record) corresponds to the time settings on the computer I want a query to show only those records which have the corresponding time from the rentals. Essentially I want to filter the records based on time.