Sounds like you're creating a monster. I'm not sure I understand why you're "rolling back" the system clock. Why not just execute your query with the criteria "sysdate - value"?

But then again .. I may be wrong.
- Dennis Miller