Hi,
I am trying to append a bind variable (:Year) and I am getting the error as "ORA-01840: input value not long enough for date format".
The sql is
Select
SUM(CASE WHEN (date_start<= to_date('01/01/'||:Year,'MM/DD/YYYY') and (actual_termination_date is null or actual_termination_date > to_date('01/01/'||:Year,'MM/DD/YYYY'))) THEN 1 ELSE 0 END ) AS CJAN
from PER_PERIODS_OF_SERVICE ppp
I have tried using to_char but of no use.
Can you please let me know what is causing the issue ???