| From: | Robby Russell <robby(at)planetargon(dot)com> |
|---|---|
| To: | Denis Zaitsev <zzz(at)anda(dot)ru> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: interval to seconds conversion. How? |
| Date: | 2004-10-27 22:45:14 |
| Message-ID: | 1098917114.4435.39.camel@vacant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | robby(at)planetargon(dot)com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 and PHP4 ---
****************************************/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Hallgren | 2004-10-27 22:48:51 | Re: Reasoning behind process instead of thread based |
| Previous Message | Tom Lane | 2004-10-27 22:44:29 | Re: Question Regarding Locks |