SQL Toolkit DBCreateParamChar and Oracle TIMESTAMP Conversion

[rmolinam1969]

Hello I'm calling a stored producedure which one of the fields on the server database is DateTime type, but there is no 'DBCreateParam' for timestamp format.

So I'm using DBCreateParamChar.

* If I use e.g. '20-MAR-2020' without time is working fine but the problem I am not storing the time.

* If I add a time '20-MAR-2020 13:22:00'  I got the Oracle error 'ORA-01830: date format picture ends before converting entire input string'.

I need to send both Date and Time.

Could somebody give an idea to get this working?

Thanks

[RobertoBozzolo]

This is a blind shot as I'm not familiar with Oracle database. I have always seen Oracle timestamps to include also fraction of seconds, so I wonder whether  '20-MAR-2020 13:22:00.0' would be accepted or not.

[rmolinam1969]

Thanks for your response,

I have also triend what you suggest with the same result.