Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f42Ki7A75418 for ; Wed, 2 May 2001 16:44:07 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by mail1.hub.org (8.11.3/8.11.1) with ESMTP id f42Ki7875414 for ; Wed, 2 May 2001 16:44:07 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f42Ki4fE020229; Wed, 2 May 2001 14:44:04 -0600 Date: Wed, 2 May 2001 14:44:04 -0600 From: Roberto Mello To: Richard Whittaker Cc: pgsql-php@postgresql.org Subject: Re: Unixtime function?... Message-ID: <20010502144404.A20145@cc.usu.edu> References: <5.0.2.1.0.20010502084535.0413d790@mekong.connections.yk.ca> <5.0.2.1.0.20010502084535.0413d790@mekong.connections.yk.ca> <20010502141107.A19986@cc.usu.edu> <5.0.2.1.0.20010502131806.03c914b0@mekong.connections.yk.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: <5.0.2.1.0.20010502131806.03c914b0@mekong.connections.yk.ca>; from richard@connections.yk.ca on Wed, May 02, 2001 at 01:20:24PM -0700 X-Archive-Number: 200105/6 X-Sequence-Number: 315 On Wed, May 02, 2001 at 01:20:24PM -0700, Richard Whittaker wrote: > > Allright, so given that, how do I get the number of seconds between two > arbitrary date/time values or even just time values, and pass that back to > PHP?... You're not going to even try to find this information in the docs???? http://postgresql.readysetnet.com/users-lounge/docs/7.1/user/functions-datetime.html hgcm-test=# select extract(epoch from timestamp 'now()'); date_part ----------- 988836181 -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer DOS = Damned Old Software