i have this code , to download datas from a valve in command window
influx -database fielddata -host xyxy.com -port xyxy -execute “select * from zones WHERE (valve = ‘101’) AND time > ‘2018-03-23’ and time < ‘2018-04-23T23:59:59Z’” -format csv > test.csv
the problem is that get timestamps like that: time:1521763242000000000
i have no clue how i can convert it…i need help:-(
i would like to have this format: 2015-07-17T20:32:58
i have read something about " precision rfc3339" but i have no clue where i have to put in the code above.
Thank you for your help.