ORA-01861: literal does not match format string

[sathee...@gmail.com]

Hi Team,

In IGI we are getting the start date/end date as below,
stardate : 2021-09-14 00:00:00
end date : 2021-12-31 23:59:59
while updating to the oracle DB it is failing with the below error,
"$$$ ERROR MESSAGE $$$java.sql.SQLDataException: ORA-01861: literal does not match the format string."

in the target, end start and end date are defined as a date type.

Now how to convert this string to date type in the AL code. So please help me with this issue.

Regards,
Satheesh G

[Eddie Hartman]

If the values you have are string values, try converting them to java.util.Date using system.parseDate() - look in the TDI/SDI Javadocs under the UserFunctions class.

Once you have a java.util.Date then you can create Attribute values of type java.sql.Date like this:

work.startdate = new java.sql.Date(system.parseDate(startdateString, "yyyy-MM.dd' 'HH:mm:ss").getTime());

If the startdate and enddate values are already date times, you can skip the parseDate() bit.

/Eddie

[sathee...@gmail.com]

Thanks, Eddie. Can you please explain some more on try converting them to java.util.Date using system.parseDate() code .
If the startdate and enddate values are already date times: Yes I'm getting both the values. possible can you give heads-up on the overall code that will help me understand more.
Regards,
Satheesh G