Showing "regular" timestamp instead of the UNIX one

Get Help
1

Hi,
I built a (simple) query/question that displays a table which has some (Date) columns who are in UNIX timestamp format, which is unrecognizable for a human being, and using an external converter on the data is a cumbersome.

Is there a way to make Metabase show the data in these date columns in a (human) readable format?

I’m sorry if this question was asked many times before or is very basic. I did a quick search and didn’t find an answer for that.

Thanks in advance.

2

Hi @AcquaAlta
Depending on the database and the column type storing the timestamp, then yes, by changing the Field Type in Admin > Data Model > (database) > (table) > (column) :gear: to one of the “UNIX Timestamp”

1 Like
3

Hi Flamber,
Thanks a lot. Your answer helped me :slight_smile: