topic Re: ORACLE: CONVERT NUMBER(17) TO STRING in QlikView https://community.qlik.com/t5/QlikView/ORACLE-CONVERT-NUMBER-17-TO-STRING/m-p/1454510#M609735 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>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.</P><P></P><P>Now i cut milliseconds from timestamp first by dividing number / 1000 on load script.</P><P></P><P>LOAD VCE_NDATE_CREATED / 1000 as VCE_NDATE_CREATED, ...</P><P></P><P>Martin</P></BODY></HTML> Mon, 15 Jan 2018 10:41:23 GMT Anonymous 2018-01-15T10:41:23Z ORACLE: CONVERT NUMBER(17) TO STRING https://community.qlik.com/t5/QlikView/ORACLE-CONVERT-NUMBER-17-TO-STRING/m-p/1454509#M609734 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>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.</P><P></P><P>Definition in oracle db:</P><P></P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189771_1.png" style="height: auto;" /></P><P>View of data in oracle db with Oracle SQL Developer:</P><P><IMG alt="2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/189772_2.png" style="height: auto;" /></P><P></P><P>View of data in Qlik Sense data manager after load:</P><P></P><P><IMG alt="3.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/189779_3.png" style="height: auto;" /></P><P></P><P>How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?</P><P></P><P></P><P>Martin</P></BODY></HTML> Thu, 11 Jan 2018 16:26:34 GMT https://community.qlik.com/t5/QlikView/ORACLE-CONVERT-NUMBER-17-TO-STRING/m-p/1454509#M609734 Anonymous 2018-01-11T16:26:34Z Re: ORACLE: CONVERT NUMBER(17) TO STRING https://community.qlik.com/t5/QlikView/ORACLE-CONVERT-NUMBER-17-TO-STRING/m-p/1454510#M609735 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>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.</P><P></P><P>Now i cut milliseconds from timestamp first by dividing number / 1000 on load script.</P><P></P><P>LOAD VCE_NDATE_CREATED / 1000 as VCE_NDATE_CREATED, ...</P><P></P><P>Martin</P></BODY></HTML> Mon, 15 Jan 2018 10:41:23 GMT https://community.qlik.com/t5/QlikView/ORACLE-CONVERT-NUMBER-17-TO-STRING/m-p/1454510#M609735 Anonymous 2018-01-15T10:41:23Z