'HH:mm:ss"),
> "-MM-dd'T'HH:mm:ss.SSSZZ")
> >>>
> >>> output:
> >>>
> >>> {"cd":"2021-02-24T12:01:01.000+"}
> >>> {"cd":"2021-02-24T12:01:01.000+"}
> >>> {&quo
st
>>> {"cd":"2021-02-26T12:01:01.000+"} << precision lost
>>>
>>> changing the conversion in UpdateRecord to this:
>>>
>>> /cd = format(toDate(/cd, "-MM-dd'T'HH:mm:ss.SSS"),
>>> "-MM-dd'T'HH:mm:ss.SSSZZ")
>>>
>>> output:
>>>
>>> {"cd":"2021-02-24T12:01:01"} << skipped
>>> {"cd":"2021-02-24T12:01:01Z"} << skipped
>>> {"cd":"2021-02-25T12:01:01.099+"} << not sure if this is correct
>>> {"cd":"2021-02-26T12:01:01.999+"} << correct
>>>
>>>
>>> Is there a way to change the timestamp parsing format on a per-record basis?
>>>
>>> Thanks,
>>> Greg
>>>
>>
>
gt;
>> changing the conversion in UpdateRecord to this:
>>
>> /cd = format(toDate(/cd, "-MM-dd'T'HH:mm:ss.SSS"),
>> "-MM-dd'T'HH:mm:ss.SSSZZ")
>>
>> output:
>>
>> {"cd":"2021-02-24T12:01:01"} << skipped
>> {"cd":"2021-02-24T12:01:01Z"} << skipped
>> {"cd":"2021-02-25T12:01:01.099+"} << not sure if this is correct
>> {"cd":"2021-02-26T12:01:01.999+"} << correct
>>
>>
>> Is there a way to change the timestamp parsing format on a per-record basis?
>>
>> Thanks,
>> Greg
>>
>
> /cd = format(toDate(/cd, "-MM-dd'T'HH:mm:ss.SSS"),
> "yyyy-MM-dd'T'HH:mm:ss.SSSZZ")
>
> output:
>
> {"cd":"2021-02-24T12:01:01"} << skipped
> {"cd":"2021-02-24T12:01:01Z"} << skipped
> {"cd":"2021-02-25T12:01:01.099+"} << not sure if this is correct
> {"cd":"2021-02-26T12:01:01.999+"} << correct
>
>
> Is there a way to change the timestamp parsing format on a per-record basis?
>
> Thanks,
> Greg
>
t;),
"-MM-dd'T'HH:mm:ss.SSSZZ")
output:
{"cd":"2021-02-24T12:01:01"} << skipped
{"cd":"2021-02-24T12:01:01Z"} << skipped
{"cd":"2021-02-25T12:01:01.099+"} << not sure if this is correct
{"cd":"2021-02-26T12:01:01.999+"} << correct
Is there a way to change the timestamp parsing format on a per-record basis?
Thanks,
Greg