Re: sysdate problem from a newbie

Hi,

Well, your format is only 14 characters and the value is 14 plus ".000"

What if you format the 14 date digits using to_char then just concatenate the ".000" to the end?

grAbbY0 wrote:

> 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 - 11:00:06 CDT