I have a table that contains duplicates and I need to keep the max data and blow away the rest. Due to requirements I cannot change the date field format and I am getting a conversion error. Any ideas?

```
DELETE from MAIN_TBL
WHERE ID NOT IN 
(
select * from
(SELECT MAX(updated_on)
FROM MAIN_TBL
GROUP BY widget_tag, ID) as TEMP
)

```

ERROR = Conversion failed when converting date and/or time from character string.