postgres insert timestamp without timezone code example

Example 1: postgres insert timestamp without timezone

CREATE TABLE timestamp_demo (
    ts TIMESTAMP, 
    tstz TIMESTAMPTZ
);Code language: SQL (Structured Query Language) (sql)

Example 2: postgres insert timestamp without timezone

INSERT INTO timestamp_demo (ts, tstz)
VALUES('2016-06-22 19:10:25-07','2016-06-22 19:10:25-07');Code language: SQL (Structured Query Language) (sql)

Tags:

Misc Example

Related