search

timescale / timescaledb-parallel-copy

A binary for parallel copying of CSV data into a TimescaleDB hypertable
https://www.timescale.com/
Apache License 2.0
370 stars 55 forks source link

Support setting session TIMEZONE #74

Open villisco opened 7 months ago

villisco commented 7 months ago

Please add option to set the db sessions timezone (inside connection string maybe?).

Example:

SET TIME ZONE 'UTC'

TIMESTAMP WITH TIME ZONE (type: timestamptz) columns in postgres use the db session timezone for date conversion.

This is needed because INSERT'ing data on DST (Daylight Saving Time) period can have some strange timestamp converting behaviors.

alejandrodnm commented 5 months ago

Hey @villisco we don't have a lot of bandwidth right now to add new features, but we welcome PRs :)