TO_CHAR can't convert a date to be inserted.

[Quoted] [Quoted] One of our developers is having problem inserting a record into a table that has a TO_CHAR() conversion. However, if he hard-codes the date into the insert(), it works.

Example:

var1 := TO_CHAR(:form_date_field, format); insert into table (....)

        values(var1,....)

This does not work!

insert into table (....)

        values('12-Dec-99 15:23',....)

This works!

What's going on? The formating is the same in both cases.

Please respond by email.

Thanks in advance!
-Mir.
Received on Mon Jun 02 1997 - 00:00:00 CEST