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?
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.