You where right, It works, the problem was in another assignment in the same UPDATE sentence.

I'm very surprise. All my live I've strugled with date format in my programs and portability issues for different database vendors and this seems to work in DB2 also.

One last question. In C# or VB The string format would be: 'yyyyMMdd hh:mm' ?

Thanks