Re: timestamp parsing

2021-02-25 Thread Chris Sampson
'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

Re: timestamp parsing

2021-02-25 Thread Mark Payne
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 >>> >> >

Re: timestamp parsing

2021-02-25 Thread Gregory M. Foreman
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 >> >

Re: timestamp parsing

2021-02-25 Thread Mark Payne
> /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 >

timestamp parsing

2021-02-25 Thread Gregory M. Foreman
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