Re: Milliseconds Timestamps

On Wed, 25 Jan 2006 14:36:16 +0100, Björn Wächter wrote:

> Hi all,
>
> what is the best way to calculate the
> miliseconds between two
> TIMESTAMP(3) WITH LOCAL TIME ZONE
> columns?
>
> Thanks Björn

I can't speak to the 'best way', but I would think the method Oracle describes in their Interval examples would point to a suitable solution. While not taking it to the millisecond, I'd hope the examples at the following URL would give a pattern that can be adapted.

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#BABBICGH

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***