Conversion failed when converting datetime

[doc4child]

FAILURE: Error writing to database:
SQLException
Conversion failed when converting datetime from character string. Query: INSERT INTO sma values (?, ?,0 ,0,0,0,0,0,0,0,0,0,0) Parameters: [0995819, 200808260357]


I am getting this error? How to fix it?

[jbartels]

Can you post your channel please?

If you are dealing with any datetime fields from a message make sure they are formatted so that your database can understand them.

Post edited by: jbartels, at: 08/28/2008 05:39

[madhup1981]

How do I address this issue?

insert into table_name
(first_name,last_name,creation_dt)
values(${firstname},${Lastname},cast(${SYSTIME} as DATETIME)).

I have tried to use cast and convert but still unable to insert data into the table. We are using SQL db and the column is datetime type.

Can you please suggest a way to address this?

[Rachel83]

Valuable information. Thank you for sharing.