Re: Compute difference between timestamps

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 4 Jun 2006 19:31:48 +0200
Message-ID: <44831903$0$20860$626a54ce@news.free.fr>

<c8s3dw_at_verizon.net> a écrit dans le message de news: 1149440112.459422.156100_at_i39g2000cwa.googlegroups.com... Michel Cadot wrote:
| > <c8s3dw_at_verizon.net> a écrit dans le message de news: 1149377499.120834.262480_at_j55g2000cwa.googlegroups.com...
|
| >
| > SQL> select t2-t1 d1, to_char(extract(second from t2-t1),'990.000') d2 from t;
| > D1 D2
| > ------------------------------ --------
| > +000000000 00:00:26.719000 26.719
| >
| > 1 row selected.
| >
| > Regards
| > Michel Cadot
|
| That only works if the interval is less than 60 seconds.

That was just an exemple.
Just make a little effort to :
- read the doc, you see extract can also extract minutes, hours, days. - complete the statement

We are not here to spend all our time to give you a complete solution. With what i give you it's really easy to get the final statement.

Regards
Michel Cadot Received on Sun Jun 04 2006 - 12:31:48 CDT