1) why is sec_session_properties.last_hit an int, rather than timestamp(0)? this makes doing pretty much any query on this nastier and probably slower than necessary. :(
2) given an int representing an interval in seconds, is there a better way to derive an actual interval type than the following?
select (my_int::int::abstime::timestamp(0)) - (000::int::abstime::timestamp(0))