I want to convert a number format YYYYMMDD stored in oracle to date format and use this for Trend reporting.I am receiving the below error
Oracle database error 1830: ORA-01830: date format picture ends before converting entire input string
Appreciate any suggestions to handle this.
Check the MAKEDATE function: Date Functions
You may also need to use LEFT and RIGHT functions and perhaps even STR to convert to a string, all depends how it is exactly once in Tableau.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...