Failed on this syntax
lazarus / 16-Databases

----------------------------------------------------------------------
pipingae · 2025-07-15 04:56

greetings,

please help with this query syntax

SUM(CASE WHEN DATEDIFF(LAST_DAY(CONCAT('+periode+',"01"))

how do i send the variable value on periode ?, cause it fails with
error when i try to run in ...

thankkkkk youuu guyssss for the solution ....

----------------------------------------------------------------------
pipingae · 2025-07-15 05:08

if i use this syntax it doesnt give me error but there is no query
result

DATEDIFF(LAST_DAY(CONCAT(:periode,"01")),piut_date)

using the parameter on sql

thanks before

----------------------------------------------------------------------
Zvoni · 2025-07-15 06:14

Which DBMS?
and what's the exact error-message?

----------------------------------------------------------------------
pipingae · 2025-07-15 06:19

dbms is using mysql error syntax is invalid

----------------------------------------------------------------------
pipingae · 2025-07-15 06:45

sorry for the inconvenience, i have the solution


thank youuuu guyssss