Getting interval in seconds?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Getting interval in seconds?
Date: 2001-06-10 02:05:51
Message-ID: 3.0.5.32.20010610100551.00feeaf0@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

Thanks,
Link.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2001-06-10 03:47:04 Re: Getting interval in seconds?
Previous Message Lamar Owen 2001-06-10 02:02:20 Re: PGDG?