At 02:51 PM 2/26/2001 +0100, guido.klapperich@... wrote:

>I have two fields in a table
>Start TimeStamp (for example 19.02.2001 8:00)
>End TimeStamp (for example 20.02.2001 9:00)
>and I want the duration between these two fields. I tried something like
>
>that
>cast ((End-Start) as Numeric(9,3))
>to get the seconds, that has gone by between these two points. But I get
>
>an conversion error. Can anybody help me.

Subtracting a time from a time gives a number of seconds. Subtracting
a timestamp from a timestamp gives a number of days.

This worked for me:

SQL> create table foo (foots timestamp, foot time, food date, fooi double
precision);
SQL> commit;
SQL> insert into foo values ('now', '11:11:11.123', 'today', NULL);
SQL> select * from foo;

FOOTS FOOT FOOD FOOI
========================= ============= =========== =======================

2001-02-26 10:07:55.0000 11:11:11.1230 2001-02-26 <null>

SQL> select cast ('now' as timestamp) - foots from foo;

0.000590277

SQL> select cast ('12:00:00.000' as time ) - foot from foo;

2928.8770

SQL> select cast (cast ('now' as timestamp) - foots as numeric (9,3)) from foo;

0.003


Regards,

Ann
www.ibphoenix.com
We have answers.