Forum OpenACS Q&A: two dates-in-PG questions

Collapse
Posted by Jonathan Ellis on
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))