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

Former Member
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