How to correct date format while export from Postico to CSV and open on Excel?

187 views Asked by At

I'm exporting my query result from Postico a PostgreSQL client.

This is how it looks like after running query on Postico - my query result

And when I export it to CSV and open with Excel, it becomes like this - my excel data

It went from "2018-09-17" to "17M09M18". I use UTF-8 as encoding type while exporting.

I'm using macOS, Postico 1.4.2 and Excel 2016.

I don't really know what's wrong. I suspect that it has something to do with Mac system but I can't figure it out.

Thank you very much for your help in advance.

0

There are 0 answers