Unix seconds formatted with data formatter are incorrect display in dashboard and query

#1

I’m recording a timestamp formatted as unix seconds in a custom event. Using Insights data formatter I convert the seconds to a timestamp. Everything looks correct here.

image
image.png1337×330 21.3 KB

Now I would like to display this value on a dashboard.
Querying the data as JSON looks fine as well:

results": [
    {
      "events": [
        {
          "timestamp": 1596181671406,
          "timestampOfOldestMessage": 1596181663.931011
        }
      ]
    }
  ]

But if I query it as a table I get this:
image
I query nothing unusual: SELECT timestampOfOldestMessage FROM Outbox

Am I missing something here? Why wasn’t timestampOfOldestMessage correctly formatted, but timestamp (as a built-in feature) was?
Is the issue related to the comma? But why would it work then in the data formatter?

Thanks and best regards!

#2

Good morning @broder.peters

That sounds like a bug - I assume that even though your timestamp is set into seconds, it may be being mistranslated as milliseconds, rather than seconds.

I’ll get this reported and confirmed with the right team. I’ll update you when I know more.

1 Like
#3

I’ve one more detail to this. Viewing the dashboard in Insights display the timestamp correctly:

image
image.png760×266 19.4 KB

(Not that this is not the timestamp from the example above)

#4

Understood! So - is this only happening for you in the New Relic One UI?

#5

Yes, it is only happening in the New Relic One UI for now.

#6

Thanks @broder.peters

Just got a bug ticket filed internally with the engineering team. Will follow up with you when I get an update.

Thanks again for reporting this :smiley:

1 Like