Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Compute difference between timestamps

Re: Compute difference between timestamps

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 04 Jun 2006 00:18:26 +0200
Message-ID: <mk2482hgv7trl3q1i27fnf8eudhlmbbams@4ax.com> 





On 3 Jun 2006 11:06:51 -0700, c8s3dw_at_verizon.net wrote:



>In Oracle database, given two timestamp columns, how do I compute the

>difference, expressed in seconds, to three decimal places? i.e. 452.936




Just subtract them, and divided them by the number of seconds per day.


--
Sybrand Bakker, Senior Oracle DBA


Received on Sat Jun 03 2006 - 17:18:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US