Hi,

using DB V9.5

How to add two timestamp column through sql query.

alter table table-name add column column-name timestamp;

A reorg is optional, but recommended, especially if you plan on updating the column for existing rows.

Thanks for u'r response,

not add columns in table .

my question is How to sum both the column that have timestamp datatype

ie.

1. select (timestamp1_col) + (timestamp2_col) from test ;

2. select sum (timestamp1_col + timestamp2_col) from test;

while exceute this command ,getting the error the following error

SQL0402N The data type of an operand of an arithmetic function or operation
"+" is not numeric. SQLSTATE=42819

SQL0402N The data type of an operand of an arithmetic function or operation "+ " is not numeric.

What result(data type and value) do you expect by adding timestamp columns?

For example:
TIMESTAMP('2010-04-27-09.13.56.234') + TIMESTAMP('2010-04-28-14.22.19.789') = ??????(what are your expected data type and value?)

thanks again

Expacting Integer datatype and value should in minute

TIMESTAMP('2010-04-27-09.13.56.234') + TIMESTAMP('2010-04-28-14.22.19.789') = xxxx minutes?

saching,

If you gave your answer to the following expression(hopefully with the way to calculate the answer),
I will try to give you DB2 SQL expression(and/or UDF) to produce the answer.

You can use only one arithmetic operation between two timestamps: "-".


Lenny