Re: Difference between two times as a numeric value in a stored procedure. [Scanned] - Mailing list pgsql-sql

> "Stijn Vanroye" <s.vanroye@Farcourier.com> writes:
> > I can't seem to find a way to substract two time values (or
> > timestamp values) and get a numeric/float value. I always get the
> > INTERVAL datatype.
>
> extract(epoch from interval) may help.
>
>             regards, tom lane
Indeed. I think I should kick myself for missing that, I have read that section af the manual four times or so, and
missedit over and over again :) 

Thanks for the help.

Regards,

Stijn Vanroye.