(Perhaps you need '>=' in the condition)
select * from production where to_date(PRODUCTIONDATE,'yyyymmdd') > trunc(sysdate,'IW');
hm wrote:One of the many reasons why storing date information in VARCHAR2 columns (especially VARCHAR2 (200)) is such a bad idea is that invalid data will get in there, causing run-time errors. Avoid converting columns like that to DATEs, if possible:
by the way: it is generally a good idea to store date values in date columns.
SELECT * FROM production WHERE productiondate >= TO_CHAR ( TRUNC (SYSDATE, 'IW') , 'YYYYMMDD' ) ;