Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group