Getting interval in seconds? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Getting interval in seconds?
Date
Msg-id 3.0.5.32.20010610100551.00feeaf0@192.228.128.13
Whole thread Raw
Responses Re: Getting interval in seconds?  (Alex Pilosov <alex@pilosoft.com>)
List 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.


pgsql-general by date:

Previous
From: GH
Date:
Subject: Re: Greetings, Thinking about converting
Next
From: Alex Pilosov
Date:
Subject: Re: Getting interval in seconds?