Re: Difference between two times as a numeric value in a stored procedure. [Scanned]

From: "Stijn Vanroye" <s(dot)vanroye(at)Farcourier(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Difference between two times as a numeric value in a stored procedure. [Scanned]
Date: 2004-06-04 14:44:57
Message-ID: 736CEAA26E7E3F48943458F760E7A326010CE4@fs1010.farcourier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> "Stijn Vanroye" <s(dot)vanroye(at)Farcourier(dot)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 missed it over and over again :)

Thanks for the help.

Regards,

Stijn Vanroye.

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2004-06-04 15:23:44 Re: Difference between two times as a numeric value in a stored procedure.
Previous Message Tom Lane 2004-06-04 14:11:33 Re: Difference between two times as a numeric value in a stored procedure.