InfluxDBStudio
InfluxDBStudio copied to clipboard
time format problem
Hi, thanks a lot for this project.
I have some data like this
In InfluxDBStudio, it shows like this
Please notice the time column in InfluxDBStudio. I can't figure out why some time shows different from some others. And the exported json and csv are different too.
The exported json is
[
{
"time": "2019-01-07T06:13:28.881825Z",
"amount": 100,
"price": 4564.1
},
{
"time": "2019-01-07T06:13:28.883825Z",
"amount": 100,
"price": 4564.1
},
{
"time": "2019-01-07T06:13:28.885825Z",
"amount": 100,
"price": 4564.1
},
{
"time": "2019-01-07T07:18:25.185801717Z",
"amount": 100,
"price": 4564.1
},
{
"time": "2019-01-07T07:18:25.915779654Z",
"amount": 100,
"price": 4564.1
},
{
"time": "2019-01-07T07:18:41.065480404Z",
"amount": 100,
"price": 4564.1
}
]
The exported csv is
time,amount,price
2019/1/7 6:13:28,100,4564.1
2019/1/7 6:13:28,100,4564.1
2019/1/7 6:13:28,100,4564.1
2019-01-07T07:18:25.185801717Z,100,4564.1
2019-01-07T07:18:25.915779654Z,100,4564.1
2019-01-07T07:18:41.065480404Z,100,4564.1
It seems InfluxDBStudio knows the right time, but lose precision in the table.