Sets the time zone the server will use to return datetime/timestamp columns. The value should be specified according to POSIX time zone specification.

Syntax

Connect-PostgreSQL -TimeZone string

Data Type

cstr

Default Value

""

Remarks

The server stores time with time zone and timestamp with time zone in UTC. If the TimeZone property is not set, the provider uses the client's local time zone.

Setting this property can be useful when you need the server to convert to a specific time zone, which is different from the client's local time zone.