sysdate problem from a newbie

Hi there,

I would appreciate some help here,

We have a table called Alarms, every day I have to delete all the alarms in this table that were created two days before the current date. (To prevent the table from being filled up). These Alarms are generated in a SCADA application which generates the time of the Alarms in a column called ITIME. The datatype is char and the value is like: 20010817164555.000 (YYYYMMDDHHMISS). I cant remove the '.000' because this has to be a standard value.
I am trying this with SYSDATE but then I get the error 'date format picture ends before converting entire input string'

Anybody got an idea??

Thanx in advance Received on Fri Aug 17 2001 - 17:46:23 CEST