On Thu, Oct 28, 2004 at 04:08:53AM +0600, Denis Zaitsev wrote:
> How can I calculate the number of second in some interval? Neither
> the secods part, nor the seconds after midnight... Just the full
> quantity of the seconds. I haven't find any function.
I think you can do that using
EXTRACT(epoch FROM interval-value)
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The problem with the future is that it keeps turning into the present"
In response to
pgsql-general by date
|Next:||From: Guy Fraser||Date: 2004-10-27 22:40:32|
|Subject: Re: '1 year' = '360 days' ????|
|Previous:||From: Denis Zaitsev||Date: 2004-10-27 22:37:21|
|Subject: Re: interval to seconds conversion. How?|