| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Richard Whittaker <richard(at)connections(dot)yk(dot)ca> |
| Cc: | pgsql-php(at)postgresql(dot)org |
| Subject: | Re: Unixtime function?... |
| Date: | 2001-05-02 20:44:04 |
| Message-ID: | 20010502144404.A20145@cc.usu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-php |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gyozo Papp | 2001-05-03 11:33:38 | Re: Unixtime function?... |
| Previous Message | Matthew Kolb | 2001-05-02 20:23:02 | Re: Unixtime function?... |