Hi guys!!
I adapted a query to create an alert for item registration. However, the "CONVERT" instruction is returning an error.
ERROR:
1). [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;328 invalid name of function or procedure: CONVERT: line 8 col 29 '' (SWEI) (at pos 112)
I need help to solve this problem!
SELECT t0."ItemCode", t0."ItemName", t0."CreateDate", T1."USER_CODE", T1."U_NAME", CASE WHEN t0."CreateDate" = CONVERT (date,getdate()) THEN 'SIM' ELSE 'NAO' end as "Incluido" FROM OITM t0 LEFT JOIN OUSR T1 ON T1."USERID" = T0."UserSign" where CASE WHEN t0."CreateDate" = CONVERT (date,getdate()) THEN 'SIM' ELSE 'NAO' end = 'SIM'
Thank you very much in advance!!!