DB Connect: Table and View Overview: Table contents: Date format incorrect
Please assist with the following? I am using DB connect to display a view from an Oracle db. The date format on the Odb itself is ie. yyyy/mm/dd, but in BW, when I view the contents of the table/view the date format is ie.12-M/AY/-0.
ALL the date fields from the applicable db is dsplayed incorrectly in BW. The 'type in DDIC' = DATS (8)
Your assistance is appreciated.