Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Difference between two times as a numeric value in a stored procedure.
Date
Msg-id 26987.1086358293@sss.pgh.pa.us
Whole thread Raw
In response to Difference between two times as a numeric value in a stored procedure.  ("Stijn Vanroye" <s.vanroye@Farcourier.com>)
List pgsql-sql
Tree view 
"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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: ERROR: duplicate key violates unique constraint
Next
From: Bruno Wolff III
Date:
Subject: Re: dynamic rules?