[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 Tom Lane 
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)

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match

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]

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

2004-10-27 Thread Alvaro Herrera 
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.

I think you can do that using

EXTRACT(epoch FROM interval-value)

-- 
Alvaro Herrera (alvherre[a]dcc.uchile.cl)
The problem with the future is that it keeps turning into the present
(Hobbes)


---(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 Robby Russell 
On Thu, 2004-10-28 at 04:08 +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.
 

SELECT extract(epoch FROM n);

n = interval

-Robby

-- 
/***
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | [EMAIL PROTECTED]
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting  Development
* --- Now supporting PHP5 and PHP4 ---
/


signature.asc
Description: This is a digitally signed message part

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

2004-10-27 Thread Michael Fuhr 
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.

test= SELECT extract(epoch FROM '5 hours 42 minutes 35 seconds'::INTERVAL);
 date_part 
---
 20555

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---(end of broadcast)---
TIP 8: explain analyze is your friend