how to get a number of seconds in some interval ?

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: pgsql-admin(at)postgresql(dot)org
Subject: how to get a number of seconds in some interval ?
Date: 2008-05-12 13:44:16
Message-ID: 482849B0.6050103@nsoft.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

Is there a good method of knowing how mutch seconds does some interval
have?? I tried my_interval / (interval '1 second'), but there is no
operator interval / interval defines (I wonder why).
Is there a method to do so?

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-05-12 14:08:55 Re: Orphan TOAST object
Previous Message Milen A. Radev 2008-05-12 11:46:41 Re: pg_dump 8.3 changes from 8.2