Pivot function columnKey: [ "_time"] - changes Timestamp and format

InfluxDB 2
1

With Pivot - used below as the last re-direct

|> pivot(columnKey: [ “_time”], rowKey: [“DESC”], valueColumn: “_value”)

image
image1115×111 8.45 KB

Without Pivot function at the end - correct time stamp like this:
2021-05-07 14:05:00 GMT+5:30

2

without Pivot function - screenshot

image
image888×131 12 KB

not only its subtracting 6 hrs but the format also is an issue.