Forum OpenACS Q&A: Response to PostgreSQL date questions
5: Response to PostgreSQL date questions (response to 1)
Posted by Michael A. Cleverly on 02/15/02 06:27 AM
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.