On Sun, 10 Jun 2001, Lincoln Yeoh wrote:
> Hi,
>
> How do I convert an interval to the number of seconds?
>
> e.g. I'd like the following to produce a result in seconds.
>
> select ('now'::timestamp - somedate)::interval from sometable;
select date_part('epoch',('now'::timestamp - somedate)::interval) from
sometable;
-alex