Hi,
I have a simple sql used in a DB2 enterprise stage. When I view data I am geting proper values for couple of date field. But when the same job accessing the same table in a different environment gives some default values like '1901-01-01' for those two date fields.The datatype is date for these fields.
Is it something related to environmental settings.
Thanks,
DB2 Date error
Moderators: chulett, rschirm, roy
Re: DB2 Date error
Have you querried the table from another tool to verify that those dates aren't really 1901-01-01 in the table in the 2nd environment? My first guess is a DB2 default value for a not nullable field.kpsita wrote:... same table in a different environment gives some default values like '1901-01-01' for those two date fields.....
Dale