Postgres Pro
Downloads
Home   >   mailing lists

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

From Tomasz Myrta
Subject Re: How do I convert an interval into integer?
Date
Msg-id 3FCF7C40.2040505@klaster.net
Whole thread Raw
In response to How do I convert an interval into integer?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
Dnia 2003-12-04 19:09, Użytkownik Wei Weng napisał:

> 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?

select extract(epoch from your_interval);

Regards,
Tomasz Myrta

pgsql-sql by date:

Previous
From: Jeff Kowalczyk
Date:
Subject: Trigger plpgsql function, how to test if OLD is set?
Next
From: Tomasz Myrta
Date:
Subject: Re: Trigger plpgsql function, how to test if OLD is set?