Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Database Adapter - Issue with datetime datatype of Database column

edited Dec 30, 2020 2:08PM in Integration 1 comment

Summary

Issue with datetime datatype of Database column

Content

Hi Everyone,

We are connecting to on-premise database and issuing insert statement. The insert statement contains a field of datatype 'datetime'. We are passing a parameterized string value ('30-12-2020') but end up in conversion/translation error. 

Example statement: insert into dbtable(id, creationDate) values (#p_id,#p_creationDate)

Can any of you please advise?

Regards,

Karthick.R

Version

20.4.2.0.0 (201009.0200.37961)
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!