On: Working with Postgres Types

[agent327]

Seconded. I now store timestamps as the number of microseconds since the epoch. It may not be as fancy as an actual timestamp type, but at least it works without surprises.

[doctor_eval → agent327]

I went down this path for a time and I recommended it for MySQL some time ago. But actually epoch time and timestamptz are equivalent. You can specify the number of decimals in a timestamptz to get to microsecond precision if you like.

[mekster → agent327]

Except you have no idea when if you look at the database manually.

[agent327 → mekster]

Luckily we provide a GUI so they can look at it in context.