Grafana filtering out milliseconds

  • What Grafana version and what operating system are you using?
    v9.4.7 (4add91f03d)

  • What are you trying to achieve?

    I am trying to display my timestamp and have it include milliseconds. Right now, I’ve verified that my timestamp is receiving milliseconds in the query inspector.

    Here is an example of my timestamp:
    timestamp:“2024-07-18T06:28:03.655”

  • How are you trying to achieve it?

    I have tried using a transformation called “Convert field type” but cannot get the formatting right I am using this as the input format but it seems it might be incorrect:
    YYYY-MM-DDTHH:mm:ss.SSS

    Example result when using that transformation:
    2024-07-18 01:23:19

    and another example when using the transformation “YYYY-MM-DDTHH:mm:ss.s”:
    2024-07-18 02:23:16.000

    I have also tried using the field override but that seems to do nothing.

  • What happened?
    The milliseconds are never included no matter how I try to format my input format.

  • What did you expect to happen?
    The milliseconds to be included

  • Can you copy/paste the configuration(s) that you are having problems with?
    image

image

Just wanna note I made a mistake when including my timestamp. There is two separate timestamps, @timestamp and timestamp. “timestamp” is the one being used, and milliseconds are filtered out from:
image

The problem remains the same apart from that.

Unfortunately I cannot upgrade at this moment. Hopefully there is another workaround

You can dig into public Grafana source code, identity commits, which will fix your problem, cherry pick them and backport back to your old/unsupported 9.4.7 version, which you need to compile/package/install then.
IMHO if you do that successfully, then you will have high chance to be hired by Grafana team :smiley: