Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Database Adapter - Issue with datetime datatype of Database column — Cloud Customer Connect
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

Received Response
11
Views
1
Comments
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!