> > I think the problem here is a type problem. The to_char is > returning a > char type and the column is a date type. To_char returns a character > string and that's failing on the insert due to the table requiring a > date type. Without knowing exactly what database you are > using I can't > give you much help making it work. In Oracle it would be something > like: > > to_date(to_char(SYSDATE, 'Dy-DD-Mon-YYYY HH24:MI'), 'Dy-DD-Mon-YYYY > HH24:MI')
Thanks. Using Oracle 8.1.6. Tried the above and got the error: DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD: oexec error)