[GENERAL] interval to seconds conversion. How?

2004-10-27 Thread Denis Zaitsev 
How can I calculate the number of second in some interval?  Neither
the secods part, nor the seconds after midnight...  Just the full
quantity of the seconds.  I haven't find any function.

Thanks in advance.

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] interval to seconds conversion. How?

2004-10-27 Thread Denis Zaitsev 
On Thu, Oct 28, 2004 at 04:08:53AM +0600, Denis Zaitsev wrote:
 How can I calculate the number of second in some interval?  Neither
 the secods part, nor the seconds after midnight...  Just the full
 quantity of the seconds.  I haven't find any function.
 
 Thanks in advance.

Oh, I'm sorry.  This is extract(epoch from interval).

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] interval to seconds conversion. How?

2004-10-27 Thread Denis Zaitsev 
On Wed, Oct 27, 2004 at 06:30:24PM -0400, Tom Lane wrote:
 Denis Zaitsev [EMAIL PROTECTED] writes:
  How can I calculate the number of second in some interval?  Neither
  the secods part, nor the seconds after midnight...  Just the full
  quantity of the seconds.  I haven't find any function.
 
 EXTRACT(EPOCH FROM interval_value)

Yes, I've already found it...  :)  Thanks anyway.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]