Skip to Content
Former Member
Mar 12, 2010 at 09:39 AM

DateTime format in stored procedure


Hi All,

Very Good Afternoon.

I am getting one error when i call the stored procedure from XI.

My date format is coming from Source end is for ex:2009-01-07.10:05:55.0

In My mapping i mapped to "DATE" constant to "TYPE" field. i am getting the below error in Communication channel


Message processing failed. Cause: Error processing request in sax parser: Error when executing statement for table/stored proc. 'XI_DATA' (structure 'StatmentName'): java.lang.NumberFormatException: For input string: "07 10:05:55.0"


How i can able to solve this issue.

Thank you very much.