prom
prom copied to clipboard
Switch timestamp to timestamptz
I'd want to look into how SQLite handles these also. But I'm thinking I should change to this for all timestamps:
timestamp with time zone
references
The SQL standard requires that writing just timestamp be equivalent to timestamp without time zone, and PostgreSQL honors that behavior. timestamptz is accepted as an abbreviation for timestamp with time zone; this is a PostgreSQL extension.
- Difference between timestamps with/without time zone in PostgreSQL
- Postgres datetime
- search: postgres timestamptz over timestamp