Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?