Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 6EED02E0039
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon, 12 May 2008 11:24:48 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 22674-03
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Mon, 12 May 2008 11:24:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211])
	by developer.postgresql.org (Postfix) with ESMTP id 355A82E0032
	for <pgsql-admin@postgresql.org>; Mon, 12 May 2008 11:24:44 -0300 (ADT)
Received: from smadev.internal.net (localhost [127.0.0.1])
	by smadev.internal.net (8.14.2/8.14.2) with ESMTP id m4CEOeCn092565;
	Mon, 12 May 2008 17:24:40 +0300 (EEST)
	(envelope-from achill@matrix.gatewaynet.com)
Received: from localhost (localhost [[UNIX: localhost]])
	by smadev.internal.net (8.14.2/8.14.2/Submit) id m4CEOcJO092564;
	Mon, 12 May 2008 17:24:38 +0300 (EEST)
	(envelope-from achill@matrix.gatewaynet.com)
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: how to get a number of seconds in some interval ?
Date: Mon, 12 May 2008 17:24:38 +0300
User-Agent: KMail/1.9.7
Cc: Julius Tuskenis <julius@nsoft.lt>
References: <482849B0.6050103@nsoft.lt>
In-Reply-To: <482849B0.6050103@nsoft.lt>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200805121724.38772.achill@matrix.gatewaynet.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200805/92
X-Sequence-Number: 29176

=CE=A3=CF=84=CE=B9=CF=82 Monday 12 May 2008 16:44:16 =CE=BF/=CE=B7 Julius T=
uskenis =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello,
>=20
> Is there a good method of knowing how mutch seconds does some interval=20
> have?? I tried my_interval / (interval '1 second'), but there is no=20
> operator interval / interval defines (I wonder why).
> Is there a method to do so?
>=20
smth like
dynacom=3D# SELECT extract(epoch from '49 hours 0 mins 12 seconds'::interva=
l);

> --=20
> Julius Tuskenis
> Programavimo skyriaus vadovas
> UAB nSoft
> mob. +37068233050
>=20
>=20



=2D-=20
Achilleas Mantzios