Change _time from RFC3339 to epoch format in Data Explorer?

, ,
1

Is there a quick way in either InfluxDB Data Explorer or using the flux language to get the epoch time of each metric in raw data view? For some reason that option is not in the GUI dropdown either.

Screenshot 2020-10-01 at 11.32.57
Screenshot 2020-10-01 at 11.32.572538×1424 643 KB

I’m trying to track down some potential missing data and want to make sure the tag/value/epoch matches what I’m sending to InfluxDB via kafka and Telegraf.

2

Hello @sgreszcz,
You can use the unix() function to return timestamps as Unix

|> map(fn: (r) => ({ r with _unix: uint(v: r._time) }))