I am copying a timestamp field from one table (the old one) to a timestamp field in another table (the new one that will replace the old one).
Code:
Insert into NEW_TABLE (
NR_DOC,
TS_INPUT
)
SELECT
NR_DOC,
TS_CREATE
FROM OLD_TABLE
;
I receive an error
[IBM][CLI Driver][DB2/NT]SQL0433N Value "2007-05-09-10.15.51.672000" is too long. SQLSTATE=22001
How can the value in one timestamp field be too long to fit in another timestamp field ??
I tried to do a TIMESTAMP(TS_CREATE), in the hope that that would ease DB2 a bit, but that trick didn't work.
dBforums
>
Copying one Timestamp to another and recieving "Value Too Long" error
06-15-07, 07:09
Linear Mode
