Displaying a nanosecond timestamp

[DanLipsitt]

I have a column containing an integer representing timestamps in nanosecond precision. I can view them as datetimes if I create a computed column where I convert them to seconds. Is there a good/performant way to do this without creating a new column? It's unclear to me how to create custom displayers or formatters, and I don't know if I can access the value of the current record from inside a format string.

[saulpw]

I think you're currently doing it the best way. If you would be willing to submit a PR against type_data.py line ~46 to make it check for numbers bigger than, say, 1e17 (1973 in time_t nanoseconds) and then use s/1_000_000_000 I think that would be peachy.