On Tue, Jun 25, 2002 at 11:58:11AM -0500, [EMAIL PROTECTED] wrote: > 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')
There's no point in formatting SysDate just to convert it back to a date. If you want to insert SysDate, you just simply insert it as: SysDate Ronald
