Hello Group!
Does anybody knows how I can get the difference between two date (timestamp)
is secondes or convert timestamp to integer or float type (in any acceptable
sense).

Thank you in advance,
Sergiy.




Wed, 18 Apr 2001 20:43:38 +0300
"Sergiy Ovcharuk" <Sergey.Ovcharuk@tessart.kiev.ua>
get difference between two timestamp value in second?
> Does anybody knows how I can get the difference between two date (timestamp)
> is secondes or convert timestamp to integer or float type (in any acceptable
> sense).

lockhart=# select date_part('epoch', timestamp 'today' - timestamp
'yesterday');
 date_part 
-----------
     86400

Thu, 19 Apr 2001 14:54:20 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: get difference between two timestamp value in second?