Re: interval to seconds conversion. How?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Zaitsev <zzz(at)anda(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: interval to seconds conversion. How?
Date: 2004-10-27 22:30:24
Message-ID: 25408.1098916224@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis Zaitsev <zzz(at)anda(dot)ru> writes:
> 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.

EXTRACT(EPOCH FROM interval_value)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Zaitsev 2004-10-27 22:37:21 Re: interval to seconds conversion. How?
Previous Message Guy Fraser 2004-10-27 22:26:13 Re: '1 year' = '360 days' ????