I am hoping someone here can help me with a Date Time format/parse. I am pulling in data from an OData REST endpoint, and the timestamps that come in aren't all in the same format, which is causing the conversion in mapper to fail. I am mapping to a SQL Server DB, column is datetime2 format. The dates come through in the following formats:
Why it isn't consistent baffles me, you would think they would want to be. I have tried so many different masks, scripts, etc. Any assistance is appreciated.