Postgres timestamps broken

I’ve got a Postgresql database with standard timestamps generated by a Rails app for fields such as created_at and updated_at. None of the column formatting options in Metabase show a correct date. The timestamps look like this:


Using the Creation time format, the output looks like this:

September 6, 52226, 2:47 AM.

Using the Creation timestamp format, the output looks like this:

January 13, 52221, 7:48 PM

I’ve tried every formatting option, including both the Unix timestamp formats.

Any ideas?

Hi @Matt-Yorkley
Microseconds are currently not supported: - upvote by clicking :+1: on the first post
You will need to create a database view that converts it to a format that Metabase supports.