Q: timestamp - timestamp - Mailing list pgsql-novice

From Sepp Rudel
Subject Q: timestamp - timestamp
Date
Msg-id 20030428085740.44009.qmail@web20501.mail.yahoo.com
Whole thread Raw
Responses Re: Q: timestamp - timestamp
List 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


pgsql-novice by date:

Previous
From: Jonathan Wright
Date:
Subject: Re: Problem in FOR loop
Next
From: Sergey Holod
Date:
Subject: Making "SECURITY DEFINER" procedures