Re: [GENERAL] interval to seconds conversion. How?
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
Re: [GENERAL] interval to seconds conversion. How?
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?
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 () "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?
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?
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?
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
[GENERAL] interval to seconds conversion. How?
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