Question : I am trying to learn more about the sys.time_zone_info table. It all seems intuitive except for the E. […]
Tag: timezone
How should query with timezone for timestamp
Question : We saved the timestamp with UTC. However, we would like to choose user to their own time zone. […]
Postgres streaming replication between hosts with different timezone
Question : I am running Postgres 9.1 on Windows 2012 servers. I am using postgres’s streaming replication to replicate data […]
Why is AT TIME ZONE nondeterministic?
Question : SQL Server 2016’s AT TIME ZONE appears to be nondeterministic. However, I haven’t been able to find documentation […]
Filter column by records matching a timezone in Postgres
Question : I want to check whether any rows in my column (TIMESTAMP WITH TIME ZONE) are not stored using […]
mysqldump between servers with different timezones (tz-utc)
Question : If I am moving databases between servers datetime/timestamp fields with different timezones; I have been doing: mysqldump –tz-utc=false […]
MySQL Timezone Resets after exiting server
Question : I am running this code to set my database’s timezone: set time_zone = “US/Eastern” This successfully changes the […]
Preserving timezones explicitly in postgres
Question : I’ve been doing quite some research on different ways of ‘seeing’ time and how to properly map it […]
Postgres automatic insert time stamp with time zone (india) [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
What is a valid use case for using TIME WITH TIME ZONE?
Question : Along the lines of this related question: What is a valid use case for using TIMESTAMP WITHOUT TIME […]