I have troubles to work with data stored as number(17) in oracle db. After loading data into app, i see a scientific representation of the number, which i can't handle.
Definition in oracle db:
View of data in oracle db with Oracle SQL Developer:
View of data in Qlik Sense data manager after load:
How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?
SOLVED: it was only a problem representing the number. So it was not possible as expected to convert number2string implicit and get first 4 chars for year.
Now i cut milliseconds from timestamp first by dividing number / 1000 on load script.
LOAD VCE_NDATE_CREATED / 1000 as VCE_NDATE_CREATED, ...