CymaticLabs/InfluxDBStudio

time format problem

Opened this issue · 0 comments

Hi, thanks a lot for this project.

I have some data like this
image

In InfluxDBStudio, it shows like this
image

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.