How do I format the following date in Boomi 2017-02-13T12:04:00.0000000-05:00. I have tried the following format. "yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fffK"-05:00
I am receiving the date in that format and moving to database.
Can you clarify what is the output you're looking to get?
Your input is "2017-02-13T12:04:00.0000000-05:00" -- are you trying to convert it to the following format: "2017-02-13T12:04:00.000-05:00" ?
What exactly went wrong when you tried to apply the mask (yyyy'-'MM'-'dd'T'HH':'mm':'ss'.'fffK')?
Retrieving data ...