Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pascos88
Creator II
Creator II

ErrorMsg: ORA-01858: a non-numeric character was found where a numeric was expected: SQL SELECT

Hi Guys I get this error when I try to load a column from sql. 

My script is : 

IndexTbl:
ULTIMO as ult
;
SQL SELECT trunc( ultimo,'YYYY') ultimo
FROM CSA_INDEX_V;

ultimo in CSA_INDEX_V is this format: 28-FEB-2019 00.00.00..

What is the problem? 

Thanks 

 

1 Solution

Accepted Solutions
pascos88
Creator II
Creator II
Author

Hi Mauritz,
yes my query work in Oracle.
I solve the problem with to_date(ultimo,'dd-mon-yyyy') directly in the view.
Not Qlik can recognize the field.

View solution in original post

4 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Pasco

Your syntax looks strange. Maybe try the following for a start:

IndexTbl:

LOAD
ultimo as ult
;
SQL SELECT Datepart( year,ultimo) AS ultimo
FROM CSA_INDEX_V;

Regards,

Mauritz

pascos88
Creator II
Creator II
Author

It is not working.. DatePart() doesn't work in Oracle 😞
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi Pascos

Sorry, I should have seen from the error that it is in Oracle (in which I do not have any experience). Does your query work in Oracle?

pascos88
Creator II
Creator II
Author

Hi Mauritz,
yes my query work in Oracle.
I solve the problem with to_date(ultimo,'dd-mon-yyyy') directly in the view.
Not Qlik can recognize the field.