Postgres Pro
Downloads
Home   >   mailing lists

how to get a number of seconds in some interval ? - Mailing list pgsql-admin

From Julius Tuskenis
Subject how to get a number of seconds in some interval ?
Date
Msg-id 482849B0.6050103@nsoft.lt
Whole thread Raw
Responses Re: how to get a number of seconds in some interval ?
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Milen A. Radev"
Date:
Subject: Re: pg_dump 8.3 changes from 8.2
Next
From: Tom Lane
Date:
Subject: Re: Orphan TOAST object