I have not been able to find a simple solution to this after searching. I have a form which updates a table and two of the columns are timestamp data type. I want DATEC to be set to the current time of the record creation, and I want DateM to be updated to the current time at record creation and at each record modification. On the page designer for both fields I have set default to plsql expression "CURRENT_TIMESTAMP"; I change both fields on the form to display only.
When I try to add a record I get this error:
"ORA-01830: date format picture ends before converting entire input string"
From what I've read this has to do with the form submitting a string into the column or something of that order, the explanation was over my head.
Is there a simple fix for this seemingly simple need?