Postgres Pro
Downloads
Home   >   mailing lists

How do I convert an interval into integer? - Mailing list pgsql-sql

From Wei Weng
Subject How do I convert an interval into integer?
Date
Msg-id 200312041309.12704.wweng@kencast.com
Whole thread Raw
Responses Re: How do I convert an interval into integer?
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Clint Stotesbery"
Date:
Subject: Re: Help converting Oracle instead of triggers to PostgreSQL
Next
From: Jeff Kowalczyk
Date:
Subject: Trigger plpgsql function, how to test if OLD is set?