Re: Unixtime function?...

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