DB2 Date Column - Displays Incorrect in view Data
Posted: Thu Sep 01, 2005 2:28 pm
Hi:
I imported the metadata from DB2 tables in mainframe using the Plug IN DSDB2. I have a date field defined as
LAST_MAINT_DATE DATE,
in DB2.
Metadata also shows as
LAST_MAINT_DATE DATE, 10
When I view data , I am seeing values as "10767 (1997-06-23)" .
If I change the SQL Type to Char , then the data is displayed in YYYY-MM-DD format.
1. Should i define he metadata as Char , though it is date field ?
2. Is there any setting I am missing ?.
Searched the forum & manuals couldn't get help.
Thanks for your responses in advance.
Rgds,
Nandha
I imported the metadata from DB2 tables in mainframe using the Plug IN DSDB2. I have a date field defined as
LAST_MAINT_DATE DATE,
in DB2.
Metadata also shows as
LAST_MAINT_DATE DATE, 10
When I view data , I am seeing values as "10767 (1997-06-23)" .
If I change the SQL Type to Char , then the data is displayed in YYYY-MM-DD format.
1. Should i define he metadata as Char , though it is date field ?
2. Is there any setting I am missing ?.
Searched the forum & manuals couldn't get help.
Thanks for your responses in advance.
Rgds,
Nandha