This content is now out of date.

Visit Our Community

Creating exact date based filters


I'm trying to create a filter that shows me data for the day 7 days previous. The oracle equivalent query would be something like trunc(date) = trunc(sysdate-7).

The use case is displaying last weeks data in an append subquery. I'm actually showing last weeks data as the master query and then appending on today so that there aren't time slices missing from last week.

I've gotten close by defining a today filter for the subquery, and then linking the master date to the today filter minus 7 days. It seems backwards though.

Is there a way to specify a filter (for oracle) that essentially forgets the time portion of a datetime/timestamp?


Forum image