ORA-01848: day of year must be between 1 and 365 (366 for leap year)
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 = 'M67-292' AND TO_DATE(s_date,'DD-MON-RR') <= TO_DATE('-1/2010','DDD/YYYY') AND TO_DATE(e_date,'DD-MON-RR') >= TO_DATE('-1/2010','DDD/YYYY')
ERROR: Error in executing SQL query

Error #7