Q: timestamp - timestamp

From: Sepp Rudel <sepprudel(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Q: timestamp - timestamp
Date: 2003-04-28 08:57:40
Message-ID: 20030428085740.44009.qmail@web20501.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

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

would produce

600

Thanks in advance.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Aaron Payne 2003-04-28 11:52:08 Re: finding records not listed in a column, Postgresql
Previous Message A.Bhuvaneswaran 2003-04-28 06:54:02 Re: Postgresql Makefile