This week's book giveaway is in the Open Source Projects forum. We're giving away four copies of Eclipse Collections Categorically: Level up your programming game and have Donald Raab on-line! See this thread for details.
Your LAST_MODIFIED_TIME is (presumably) a date-time, but you are comparing it with character values from your TO_CHAR functions. Leave all the dates as dates and it should work. Also, you can use "BETWEEN date1 AND date2" to catch dates inside a range.
No more Blub for me, thank you, Vicar.
I don't even know how to spell CIA. But this tiny ad does: