Re: how to get a number of seconds in some interval ?

=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



--=20
Achilleas Mantzios

--=20
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin