Change time format in Dashboards Logs

[dgr75]

I want to limit the output of the time field to YYYY-MM-DD hh:mm:ss

[saipradeepmtech]

how about Transformations using SQL where we need it.
``
SELECT DATE_FORMAT(timestamp, ‘%Y-%m-%d %H:%i:%s’) AS ts, value
FROM metrics
``

[dgr75]

Can you please help me? I don’t know how to incorporate this into the query. If I use it as is, no data is displayed.
My query:

from(bucket: “iobroker_all”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Weather”)
|> filter(fn: (r) => r[“_field”] == “value”)

[yosiasz]

Can you leverage transformation and format the dat time to what you desire

[dgr75]

Sorry, but I’m a beginner. I’ve posted the problem on Gemini, but I can’t get any further there either.

There is also a difference in the presentation:

[yosiasz]

Did you try what was recommended? Transformation and of date time field formatting?

[dgr75]

the final result according to Gemini’s suggestion:

tested in InfluxDB v2.7.12

import "date"
from(bucket: "iobroker_all")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Wetter")
  |> filter(fn: (r) => r["_field"] == "value")
  |> map(fn: (r) => ({r with formatted_time: date.formatTime(t: r._time, format: "%Y-%m-%d %H:%M:%S")}))


error @6:46-6:50: record is missing label formatTime

I have now posted the problem in the influx forum

[dgr75]

During the time transformation, the new format is still displayed in Table View:

When I switch from Table View, there is no display:

[dgr75]

Solved:
In Visualizations, select “Table” instead of “Logs.” Then Transformation->Format time will work.