PostgresSQL support for nanosecond timestamps

I have a Postsgresql table that is has 3 bigint columns one of which is being used as the time field. I am encountering two issues:

The first issue is related to the display of the time value:

I have a table panel, and the query is as follows:

SELECT my_timestamp as time ,column2,column3 FROM my_table
WHERE $__unixEpochNanoFilter(my_timestamp)
ORDER by my_timestamp
limit 15
I have observed the following:
The time display is incorrect. It would appear that the timestamp is being interpreted as milliseconds.
If I query as follows:
SELECT my_timestamp/1000000 as time…
the time displayed is correct.

The filtering using __unixEpochNanoFilter appears to be ok.

How can I ensure that the timestamp is interpreted as nanoseconds?

If influxdb is used as datasource, it is assumed that the timestamps are nanosecond.

It seem not to be possible to configure the type of the timestamp,
either at the datasource or at the dashboard level.

The second issue is with the display of large values of column3.
The last digit here is always 0.
If I modify the query as follows :
SELECT …column2,column3%10
the correct value is displayed.

Any suggestions on how to configure my panel to display these values correctly would be gratefully received.

I am running Postgres 11.4 and Grafana 7.0.6

Thank you in advance.

If I query as follows:
SELECT my_timestamp/1000000 as time…
the time displayed is correct.

How can I ensure that the timestamp is interpreted as nanoseconds?

What is the problem with the solution you show above?

The second issue is with the display of large values of column3.

If I modify the query as follows :
SELECT …column2,column3%10
the correct value is displayed.

You again appear to have posted an answer to your own question.

What’s the problem with that solution?

Antony.

Sorry, I misspoke there:
Thank your for the fast response.
what I meant to say is that without the modulus, the last digit is always 0.
With the modulus ( which only displays the last digit), the last digit is correct.
I would like to see the unmodified number correctly.
I was showing that it appears to be a display issue.