Grafana miscalculating time from timestamp

  • What Grafana version and what operating system are you using?
    Grafana version is 9.5
    OS Windows 8

  • What are you trying to achieve?
    Calculate the elapsed time since containers started.

  • How are you trying to achieve it?
    Using metrics container_start_time

  • What happened?
    container_start_time is returning a timestamp. On converting the Value field to Time unit, Grafana is miscalculating it as 20 Jaunuary 1970.

  • What did you expect to happen?
    Grafana should calculate correct time from timestamp coming from Prometheus.

  • Can you copy/paste the configuration(s) that you are having problems with?
    An example timestamp: 1658903170
    On converting to time using Convert field type transformation: 1970-01-20 10:18:23.170

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors noticed

  • Did you follow any online instructions? If so, what is the URL?
    NA