Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB Connect: Table and View Overview: Table contents: Date format incorrect

Good day

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.

Cj

replied

In the View in the select statement at Oracle side.

Convert date to YYYYMMDD format.

Its some simple statement like YYYYMMDD ( <date field> ) or something like this not sure.

Hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question