ORA-01841: (full) year must be between -4713 and +9999, and not be 0
SELECT v.did FROM v_security v INNER JOIN v_itemvar i on v.did = i.dataid WHERE v.d_class = 'LPM' AND v.seclevel = 2 AND (UPPER(i.variant) = UPPER('Plots') OR UPPER(i.alias) = UPPER('Plots')) AND site = 'M52-005' AND TO_DATE(s_date,'DD-MON-RR') <= TO_DATE('031/-1','DDD/YYYY') AND TO_DATE(e_date,'DD-MON-RR') >= TO_DATE('001/-1','DDD/YYYY')
ERROR: Error in executing SQL query

Error #7