Postgres Pro
Downloads
Home   >   mailing lists

Convert an interval in seconds - Mailing list pgsql-sql

From Blaise Carrupt
Subject Convert an interval in seconds
Date
Msg-id 200101241338.NAA16274@mjtsa.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Use of INNER JOIN and others ??!?
Next
From: "David Wall"
Date:
Subject: blobs and small binary objects