Convert an interval in seconds

From: Blaise Carrupt <bc(at)mjtsa(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Convert an interval in seconds
Date: 2001-01-24 13:38:31
Message-ID: 200101241338.NAA16274@mjtsa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all !

I've search all the doc to find a function which would allow me to convert an
interval into a number of seconds. What I get is @ 1 hour, what I would like is
-3600. I'd think to something like select interval('sec', myTime) - Ingres
syntax - but it doesn't work.

Does somebody has an idea ?

______________
B. Carrupt

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-24 15:34:29 Re: How to change the ownership of the table?
Previous Message Bruce Momjian 2001-01-24 12:19:08 Re: Use of INNER JOIN and others ??!?