Timestamp format error

pratapsriram · Post by **pratapsriram** » Wed Jan 18, 2012 3:58 pm

I am getting this error. I have not found any entry for such. Has anyone come across this type of error before and if so, how to resolve it?
DB2_TISUITE_WORK,0: Invalid timestamp value in setOutputFieldAsTimeStamp() for field '184' in output dataset '0'. Time stamp string = 0000-00-00 00:00:00.000000, format string = %yyyy-%mm-%dd %hh:%nn:%ss.6.

Kryt0n · Post by **Kryt0n** » Wed Jan 18, 2012 4:31 pm

For a start, 0000-00-00 00:00:00 is not a valid timestamp so that may be the cause

SURA · Post by **SURA** » Wed Jan 18, 2012 5:10 pm

I trust it may be Data issue / Format mismatch.

What is your source and how the data is for this column?

DS User

chulett · Post by **chulett** » Wed Jan 18, 2012 5:29 pm

Kryt0n wrote:For a start, 0000-00-00 00:00:00 is not a valid timestamp so that may be the cause

This.

pratapsriram · Post by **pratapsriram** » Fri Jan 20, 2012 10:00 am

I don't know what has fixed the issue, but now its not coming after I changed the prefetch rows to a smaller value of 100 from 2000.

DSXchange

Timestamp format error

Timestamp format error

Re: Timestamp format error