Postgresql date timezone issue -

i have pg database column type timestamp time zone. inserted following date:

2016-08-01 00:00:00 gmt

however, in database, shows as:

2016-07-31 20:00:00-04

does know might going on?

thanks in advance!

despite name, timestamp time zone doesn't store time zone. uses session's time zone normalize utc, , stores utc. on retrieval converts utc session time zone.

you can change session time zone using set time zone command. preferably, should use the standard iana time zone identifiers. example:

set time zone 'europe/paris' 

or

set time zone 'utc' 

alternatively use timestamp [without time zone] type instead, no conversions.