Question: how to create table with timestamp in postgres?
Answer: PostgreSQL timestamp example CREATE TABLE timestamp_demo ( ts TIMESTAMP, tstz TIMESTAMPTZ ); Next, set the time zone of the database server to America/Los_Angeles . Then, insert a new row into the timstamp_demo table: INSERT INTO timestamp_demo (ts, tstz) VALUES('2016-06-22 19:10:25-07','2016-06-22 19:10:25-07');