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 |
ro***@planetargon.com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 and PHP4 ---
****************************************/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
iD8DBQBBgCT60QaQZBaqXgwRAkqNAKC87oW/FxqFqxwliH3x86TIB1/zFACgv07v
2mHPFzhKbu4RuJBWpvRxW2E=
=ftX+
-----END PGP SIGNATURE-----