Remove Timezone information from datetime field using spath while reading data from json file

[Skhunte]

Hi team,

I am extracting JSON data using spath. There is done datetime field and which is coming with zone name as below.

Skhunte_0-1604500410305.png

I want it without UTC word. like 2020-11-03 10:10:10 

Can we do this using spath.

if yes please provide me example.

thank you for your help.

Sanket K

[isoutamo]

Can you post your original json?

[Skhunte]

Thank you for your comment. 

to be honest i don't have JSON now because I am getting CSV as source which has JSON as source.

I have to suggest solution to trim zone factor. 

If you can take any JSON file for sample which has time with zone as mentioned in my original post that will help me.

Thank you agian.

Sanket