| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Sepp Rudel <sepprudel(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Q: timestamp - timestamp |
| Date: | 2003-05-01 18:16:21 |
| Message-ID: | 200305011116.21630.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Sepp,
> this must be a no-brainer but I just can't get this
> working: I'd like to substract one timestamp from
> another and have the result as integer/seconds, e.g.:
>
> 2003-04-28 14:10:00+01 - 2003-04-28 14:00:00+01
SELECT extract(epoch FROM '2003-04-28 14:10:00+01'::timestamptz) -
extract(epoch FROM '2003-04-28 14:00:00+01'::timestamptz)
--
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | eurlix | 2003-05-01 20:33:31 | Re: Optimizing POSTGRESQL config |
| Previous Message | Tom Lane | 2003-05-01 17:13:16 | Re: Installing postgres in home directory |