Forum OpenACS Q&A: Response to PostgreSQL date questions

Oracle does date arithmetic in units of "days". So subtract one date from the other and then multiply by the number of seconds in a day (86400) to get the number of seconds in the interval in question.