Product/components used and version/fix level:

webMethods.IO Integration version 11.0.0.0

Detailed explanation of the problem:

I need to insert the dateOfBirth in a PostgresSQL. The field in the DB is an object.
How can I convert a string in wm.IO to an Object for the DB?
I tried to map the string to the object, but this causes an error in the DB insert.

Error messages / full error message screenshot / log file:

Question related to a free trial, or to a production (customer) instance?

Question is related to a free forever licence

Hi Heiko.

which product do you use to connect to the PostgreSQL?

If I remember right, the WmJDBCAdapter was able to handle this in Designer when developing the insert service.
At least on prem.

Regards,
Holger

I’m using webMethods.IO in the cloud.

I assume you want to feed a Postgres table column that has the type “date” with the Database connector. If not please share your table definition as well as the name of the connector you’re using.

Here’s how I populate date columns in Postgres:

1. When creating the custom insert or update action, I make sure to activate the “Convert selected to String” option. Here you can see I have a date column in my table.
   

   https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/0e8938b67ff69d7fc539ab3d46177cfebb928432_2_1035x630.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/0e8938b67ff69d7fc539ab3d46177cfebb928432_2_1380x840.png 2x" data-dominant-color="FBFCFC">

   image1916×1168 117 KB

2. When sending data to the connector, I send date strings with the following format: YYYY-MM-DD

For timestamp columns, the string format needs to be YYYY-MM-DD HH:mm:ss.SSS

That’s exactly how it works. Thanks!