Re: sysdate problem from a newbie

thank you for your help I appreciate it!!

"Ben Dover" <noway_at_io.org> wrote in message news:3b7d30d5$1_at_news....
> Not sure if I understand your problem, but try this.
>
> delete from alarms
> where sysdate-2 < to_date(substr(itime,1,14),'yyyymmddhh24MIss')
>
> "grAbbY0" <grAbbY0_at_hotmail.com> wrote in
> 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:21:47 CEST