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