Skip to Content
0
Jan 25, 2021 at 11:57 AM

New registrations alert

89 Views Last edit Jan 25, 2021 at 12:00 PM 2 rev

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!!!

Attachments

error-convert.jpg (20.3 kB)