This is more of a bug than a feature request. Currently when using a filter “in the last 2 hours” (or any similar date logic) on a TIMESTAMP WITH TIME ZONE (or TIMESTAMP WITH LOCAL TIME ZONE) data type, APEX IR and IG add
and "MY_COLUMN"between sysdate-numtodsinterval(:apex$f1, :apex$f2) and sysdate
This should be
and "MY_COLUMN"between systimestamp-numtodsinterval(:apex$f1, :apex$f2) and systimestamp
The use of sysdate does an implicit conversion that does not take into account any time zone information and therefor does not provide the right result (when the timestamp time zone is not the same as the database time zone).
Every time you use a TIMESTAMP WITH TIME ZONE in an IR or IG.
Preferred Solution (Optional)
See "Idea Summary"