Re: sysdate problem from a newbie

try

delete from alarms
where to_date(substr(itime,1,8),'YYYYMMDD') < sysdate -2

"grAbbY0" <grAbbY0_at_hotmail.com> wrote in message news:j%af7.458044$u5.9673637_at_zwoll1.home.nl...
> 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 Sat Aug 18 2001 - 14:31:53 CEST