Strange Data

ratheeshknair · #1 (**permalink**) 08-20-09, 06:24

Hi Experts,

I have a timestamp column in which am getting null as result when i query through an application. I dont have direct access to the db and only way is through that appliation. I have checked the length of the column and its showing 4. i hope string null is not allowed in timestamp colum.

Can anyone please tell me is there any particular date to which JAVA responds like this?

TIA

ARWinner · #2 (**permalink**) 08-20-09, 08:01

Timestamp columns should be length 10. I would guess that the column is question is not a Timestamp, but a string where they are putting a time into.

Andy

ratheeshknair · #3 (**permalink**) 08-21-09, 06:49

Thansk Andy,

I have checked with the client and the datatype is DATE sorry for putting it as TIMESTAMP.

ARWinner · #4 (**permalink**) 08-21-09, 08:01

Dates in DB2 are indeed length 4. If you are getting null back from this column, then it can be NULL, which means that there is no date value stored there. It is not stored as a string, it is stored as binary. The application should handle null values properly. It is doesn't, then it is a bug that needs to be fixed.

Andy