How calculate date/time difference in DB2

I found this example in MYSQL:
create table events
( id integer not null primary key
, datetime_start datetime not null
, datetime_end datetime not null
);
insert into events values
( 1, '2006-09-09 14:00', '2006-09-09 16:00' )
,( 2, '2006-09-10 09:00', '2006-09-10 17:00' )
,( 3, '2006-09-11 13:30', '2006-09-11 14:45' )
,( 4, '2006-09-12 09:00', '2006-09-15 17:00' );

select id
, datetime_start
, datetime_end
, datetime_end - datetime_start as diff
from events
id datetime_start datetime_end diff
1 2006-09-09 14:00 2006-09-09 16:00 20000
2 2006-09-10 09:00 2006-09-10 17:00 80000
3 2006-09-11 13:30 2006-09-11 14:45 11500
4 2006-09-12 09:00 2006-09-15 17:00 3080000

Can we get in DB2 date/time difference in one query?
Or we have calculate it separate?
Thank's in advance Leny G.

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/ibm-db2/200809/1

"lenygold via DBMonster.com" <u41482@uwe> wrote in message
news:8997776c4097f@uwe...
>I found this example in MYSQL:
> create table events
> ( id integer not null primary key
> , datetime_start datetime not null
> , datetime_end datetime not null
> );
> insert into events values
> ( 1, '2006-09-09 14:00', '2006-09-09 16:00' )
> ,( 2, '2006-09-10 09:00', '2006-09-10 17:00' )
> ,( 3, '2006-09-11 13:30', '2006-09-11 14:45' )
> ,( 4, '2006-09-12 09:00', '2006-09-15 17:00' );
>
> select id
> , datetime_start
> , datetime_end
> , datetime_end - datetime_start as diff
> from events
> id datetime_start datetime_end diff
> 1 2006-09-09 14:00 2006-09-09 16:00 20000
> 2 2006-09-10 09:00 2006-09-10 17:00 80000
> 3 2006-09-11 13:30 2006-09-11 14:45 11500
> 4 2006-09-12 09:00 2006-09-15 17:00 3080000
>
> Can we get in DB2 date/time difference in one query?
> Or we have calculate it separate?
> Thank's in advance Leny G.

Try the SQL Reference manual Vol 1
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg27009727