How do I convert an interval into integer?

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How do I convert an interval into integer?
Date: 2003-12-04 18:09:12
Message-ID: 200312041309.12704.wweng@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I want to convert an interval (from substraction between two timestamps) into
a integer that represents how many seconds that interval has. How do I do
that?

I am using postgresql 7.3.1

Thanks

Wei

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Kowalczyk 2003-12-04 18:18:02 Trigger plpgsql function, how to test if OLD is set?
Previous Message Clint Stotesbery 2003-12-04 17:52:40 Re: Help converting Oracle instead of triggers to PostgreSQL