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

[pascos88]

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 

[Mauritz_SA]

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]

It is not working.. DatePart() doesn't work in Oracle 😞

[Mauritz_SA]

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 · Accepted solution]

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.