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

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

pgsql-general by date

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

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