3 ms·
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 withou
by agent327 5y ago
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.
- mekster 5y agoExcept you have no idea when if you look at the database manually.
- agent327 5y agoLuckily we provide a GUI so they can look at it in context.
- doctor_eval 5y agoI 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.